topic Setting a chart to a specific granule level in QlikView

Setting a chart to a specific granule level

Sat, 08 Feb 2014 06:00:02 GMT

Hello,

I was wondering if someone could possibly solve my problem.

I need to set a particular chart(may be bar) to a specific granule level so that filter should get ineffective after that and then other chart to another granule level from the same table.

Basically, I have to do some sort of comparison between charts. If anybody could answer this that would be helpful.

Regards,

Varun

Re: Setting a chart to a specific granule level

MK_QSL — Sat, 08 Feb 2014 07:01:59 GMT

Dear Varun,

There is a good functionality in QlikView to compare two different Dimension over the same expressions.

Alternate State

Re: Setting a chart to a specific granule level

Sat, 08 Feb 2014 08:54:12 GMT

Hi Manish,

Thanks for your help.

I will try to implement using 'Alternate State' and I think this should work. Incase if I am facing any issues I would reach out for help again.

Kind Regards,

Varun

Re: Setting a chart to a specific granule level

MK_QSL — Sat, 08 Feb 2014 09:02:09 GMT

Please check enclosed file..

If you question resolved, please close this thread by choosing CORRECT or HELPFUL answer.

Thanks

Re: Setting a chart to a specific granule level

Sat, 08 Feb 2014 13:53:59 GMT

Thanks Manish,

Appreciate your help, this has solved my problem.

I do have one more question around this:- If I were to create one bar chart with 2 expressions, can I use Alternate state between them? Basically, Instead of creating two different charts can I use only one chart with two expressions for the comparison and do some sort of Alternate state setting between them? I think I may have to use combination of Alternate and set analysis...

Thanks again!!

Varun

Re: Setting a chart to a specific granule level

Sat, 08 Feb 2014 13:55:08 GMT

And I cannot open QWV file you sent as I am using personal edition.. Soon I will be getting licensed version of it..

Re: Setting a chart to a specific granule level

MK_QSL — Sat, 08 Feb 2014 13:59:14 GMT

You can...

Try below where S1 and S2 are two different Alternate States

=sum({S1}Sales)

and

sum({S2}Sales)

Re: Setting a chart to a specific granule level

MK_QSL — Sat, 08 Feb 2014 14:04:08 GMT

Consider that you want to compare all customer's this year vs last year sales.

Create Two Different Alternate State S1 and S2

Now Create Two Different List BOX with dimension Year... One List Box is having Alternate State S1 and other with S2

Create a Bar Chart.. Alternate state should be default

Dimension = Customer

Expression 1 = sum({<Year = S1::Year>}Sales)

Expression 2 = sum({<Year = S2::Year>}Sales)

Hope this helps.

Re: Setting a chart to a specific granule level

Sat, 08 Feb 2014 14:08:53 GMT

Right.. Nice Idea.. I am sure this would work.. Thanks

Re: Setting a chart to a specific granule level

MK_QSL — Sat, 08 Feb 2014 14:12:56 GMT

IF you think that this will solve your problem, kindly close this thread by selecting CORRECT answer.

Re: Setting a chart to a specific granule level

Sat, 08 Feb 2014 14:15:26 GMT

Done that..