Hi all. I am new to QlikView and i have to say that for the moment it is a real chalange to understand what is the best way to build a data model.
I have many questions that the training i did for a week did not answer them. It was just basics about qlikview technical part.
I would like to know which is the best way for example to put on a report aggregated data ? Aggregate it in front end ? Create aggregate tables in the backend ?
If i do it the backend then i will have problems with dates - calendars, etc...
This is an old post, but for the benefit of anyone (else) who finds it in Google results, I'll share this comment: Store data at the lowest practical atomicity in your warehouse, and pull that into QlikView. QlikView can handle large data sets quite well, and will aggregate the data without any trouble.
