topic Set Analysis help in QlikView

Set Analysis help

Wed, 15 Feb 2012 12:54:14 GMT

Hi,

I have a requirement to show a bar chart for year wise sum of amounts. For this I have created a bar chart with 'Year' as dimension and 'Sum(Value') as expression. This is working fine.

But my requirement is, in each bar where it is showing data for that year I want to show data for >= that year. Means bar for 2010 should show sum of all values where year >= 2010 instead of year = 2010. The same should happen for 2011 bar and etc..

COuld you please help me with an set analysis expression to achieve this.

Sample qvw attached with this post.

Regards,

Murali

Set Analysis help

stephencredmond — Wed, 15 Feb 2012 12:59:18 GMT

Hi Murali,

Use the Above function:

sum(Value) + above(sum(Value))

Regards,

Stephen

Set Analysis help

Wed, 15 Feb 2012 13:03:18 GMT

Tried that it didn't help.

It is basically showing 100 for 2010. Which is wrong.

Re: Set Analysis help

lironbaram — Wed, 15 Feb 2012 13:08:58 GMT

try

this example

Set Analysis help

Wed, 15 Feb 2012 13:49:55 GMT

Thanks a lot for the response but still it is not as per my requirement.

The bar for 2010 should show 1000 and for 2011 it should show 900 etc...

Re: Set Analysis help

Anonymous — Wed, 15 Feb 2012 13:52:49 GMT

Hope the attached qv file will ve help to solve your problem

Regards

Ashok

Re: Set Analysis help

lironbaram — Wed, 15 Feb 2012 13:52:52 GMT

check this one

Re: Set Analysis help

Wed, 22 Feb 2012 07:39:42 GMT

All,

The suggested solution didn't help me to solve my problem.

May be that I haven't described my problem correctly to this group.

Now attached is the updated QVW with the issue I am facing.

Any help?

Regards,

Murali

Re: Set Analysis help

jagan — Wed, 22 Feb 2012 08:12:56 GMT

Hi Murali,

Please check attached file. Hope this helps you.

This is an alternate approach, if you need only two years this would be helpful. If you need extra others add some more expressions.

Regards,

Jagan.

Re: Set Analysis help

Wed, 22 Feb 2012 08:43:36 GMT

I have already given this alternative solution, but business wants a stack graph. One bar for each year stacked for grip and non grip.

Any other solution?

Re: Set Analysis help

jagan — Wed, 22 Feb 2012 10:13:15 GMT

Hi,

Check the attached file hope this suits better for your requirement.

Regards,

Jagan.

Re: Set Analysis help

Wed, 22 Feb 2012 12:05:59 GMT

Its working perfectly. Thanks a lot.