What is our primary use case?
We use this solution for ETL, Analytics, Reporting, Automation, Integration between data sources (cloud, local, spreadsheets, etc), Data Scrub for Migration to new software, and automation of sending files to banks instead of using EDI, Positive Pay, etc.
How has it helped my organization?
This solution has simplified getting to and understanding our data, no matter where it is housed.
What is most valuable?
The most valuable features are the ETL, automation, and ease of use by the user population.
What needs improvement?
This solution would be improved with the inclusion of a feature that would allow us to add a common library of (our) commands used in load scripts and expressions, so with a keyword, we would get a drop down to select the command we are looking for, as opposed to the generic help. I keep them all in OneNote now and copy and paste them in, then change the field names. This addition would really save time.
Convert date-time stamp to just a normal date in the Load script - so we can match to the company calendar for Model Year / month etc , Fiscal Year /month / week of year/ week in year
date(floor(DTTMSTAMP),'MM/DD/YYYY') as TransactionDate,
Storing QVD's: (this is the path needed from a Data Loader)
STORE SummarySalesAggregate INTO [..\QVDData\SummarySalesUnitsAndDollars.qvd];
Sorted and Count for creating Arrays:
Left join (SummarizeSales2)
if(peek('Option_Inv',-1)<> Option_Inv,1, Peek('counter',-1)+1) as counter
Order by Option_Inv asc, Line_No asc;
For how long have I used the solution?
Since May 2013.
What do I think about the stability of the solution?
What do I think about the scalability of the solution?
How are customer service and technical support?
I have never worked with Qlik Customer Service directly.
Which solution did I use previously and why did I switch?
How was the initial setup?
it wasn't bad. We did need some consulting advise on the set up in the server...but designing the organization and naming conventions should be up to you. We took the consultants advise and ended up renaming, changing almost everything as far as naming conventions
What about the implementation team?
started with a consultant, didn't use them long.
What's my experience with pricing, setup cost, and licensing?
keep working with the Company to get the pricing you need.
Which other solutions did I evaluate?