topic Re: Dimensionality and set analysis in QlikView

Dimensionality and set analysis

Fri, 24 Aug 2012 19:03:52 GMT

Hi friends,

Please help me out in resolving this , I have the data as below in the raw data sheet and need the result as in the result image ,dont know how can that be done using set analysis and dimensionality in qlikview ,kindly help

Raw data :

Result :

the amounts are identified in the ranges as 1 and are finally the amounts are summed at the bottom of the range column and are displayed as below

Kindly hlep me out how can this be possible

sample excel sheet is attached herewith for input source

Kind Regards

Anand

Re: Dimensionality and set analysis

Sat, 25 Aug 2012 10:22:29 GMT

Hello Anand,

Check the attached document.

Hope this helps.

Re: Dimensionality and set analysis

Sat, 25 Aug 2012 11:21:06 GMT

Hi Anand,

the attached app is not exactly your look and feel, but check it out anyway.

Regards, Roland

Re: Dimensionality and set analysis

SunilChauhan — Sat, 25 Aug 2012 18:21:27 GMT

see the attched file and attached Excel

hope this helps

Re: Dimensionality and set analysis

Mon, 27 Aug 2012 11:10:40 GMT

Cool guys.. Thanks a tonne , it solved my problem to an extent

and the current issue was, like if i hav same countries in the source file like in the img attached, the result should be like the way it is in the results page image.

its should sum the amount and should display at the bottom along with an extra row displaying the sum of counts as well

and the two same counties amount should be summed and the count should be 1 instead of 2 and it should fall in the range after summing.

Kindly help guys

Re: Dimensionality and set analysis

Mon, 27 Aug 2012 19:39:54 GMT

Hi again Anand,

In my previous reply, I already assumed you would have more than 1 row referring to the same country and thus, added the modified syntax commented in the 3rd expression of the pivot.

Anyways you can find now attached the document with both of your requests.

Check the "presentation" tab (label for totals, multiline settings) and the "visual cues" tab for the changes.

There might be other ways to handle it, hope this one suits you

Re: Dimensionality and set analysis

Wed, 29 Aug 2012 14:28:27 GMT

Hi bakhache,

It was gr8, thanks a ton, it worked perfectly..............

Thanks Once again !!!

cheers

Anand

Re: Dimensionality and set analysis

Thu, 30 Aug 2012 05:09:19 GMT

You're welcome Anand, I'm glad I could help.

Cheers