topic Re: One field to 100% graph in QlikView

One field to 100% graph

Wed, 03 Apr 2013 16:20:27 GMT

Hi, I'm busy to build a chart with a cummul.

I will show my case with a simple example.

ID Cat Price

-----------------------------

1 A 50

2 B 10

3 C 20

4 D 30

Now my question: I want to make a line graph with Cat D (Category D) as 100%.
So Category A would be higher than 100%...

How can I fix this?
Should I make calculeted dimension, with a where statement where stands: Where Cat = D???

Please some help?

Regards,

Re: One field to 100% graph

Gysbert_Wassenaar — Thu, 04 Apr 2013 08:06:01 GMT

You can add a variable, e.g vPriceD, as =sum({<Cat={'D'}>}Price). Then in your chart use Cat as dimension as before. As expression you can use sum(Price)/$(vPriceD). See attached example.

Re: One field to 100% graph

Fri, 05 Apr 2013 08:40:56 GMT

Maybe stupid question, where did you declare the variable 'vPriceD'?
I thought you must made the variables in the script?

Re: One field to 100% graph

kaushiknsolanki — Fri, 05 Apr 2013 08:47:10 GMT

Hi,

Go to Settings -> Variable Overview.

Regards,

Kaushik Solanki

Re: One field to 100% graph

Fri, 05 Apr 2013 08:51:32 GMT

Thanks Gysbert!