topic Comparative Analysis in QV10 manually in QlikView

Comparative Analysis in QV10 manually

Tue, 13 Dec 2011 13:43:05 GMT

Hi Everyone,

I routinely need to create the ability for the end-user to compare 'states' based on selections - creating indexes etc...

Does anyone have a good way to do this in QV10 (i.e. prior to Qtech's new Comparative Analysis feature)?

Normally I have to replicate the dataset with the desired fields and then have separate list boxes that are the same but running of copied tables to achieve this. It's fine for smaller datasets but with really large datasets it gets complicated and slows that application down due to the increased data in memory.

Any tips/tricks would be greatly appreciated!

An example:

Compare Males between 25-30 with Females 35+ ... obviously I cannot make these selections indepentently on the same list box so a solution to allow this possibility is required.

Thanks

Gareth

Comparative Analysis in QV10 manually

fosuzuki — Wed, 14 Dec 2011 13:47:36 GMT

Hi,

I'm not sure if what I do is the best solution, but I usually create one data island for each selectable dimension, and then link them to the main fact table with a lot of set analysis. So, in your case I'd create only one fact table and two data islands, one for each gender.

Let's see if other experts have different approaches...

Regards,

Fernando

Re: Comparative Analysis in QV10 manually

Wed, 02 Jan 2013 12:04:23 GMT

Can u provide me an example of that..

Re: Comparative Analysis in QV10 manually

fosuzuki — Fri, 04 Jan 2013 17:58:46 GMT

Hi,

just found in my computer an interesting qvw (kinda old, don't remember where I got it...) with an example on using macros, set analysis and bookmarks to simulate alternate states. But it has nothing to do with my previous suggestion.

Hope this helps you

Fernando