topic Re: line chart display % in QlikView

line chart display %

Fri, 25 Nov 2016 20:48:35 GMT

Hi Experts,

I need to display a static 100% on this graph. Even whennothing is selected from TPName, the lines should display the utlization for that TPName. E.g. for the below TPName, the graph shoud display at 33% for all codes even if I do not select the TPName.

Code	TPName	Utilization
		100%
992ZZ	Pjiuaf Irbvmykxlaql	33%
992Z2	Pjiuaf Irbvmykxlaql	33%
992Z4	Pjiuaf Irbvmykxlaql	33%
992Z5	Pjiuaf Irbvmykxlaql	0%

When that specific TPName is selected

When nothing is selected the graph resizes to 5 %

Please help!

Re: line chart display %

sunny_talwar — Fri, 25 Nov 2016 22:41:08 GMT

Not sure what your expression is, but assuming it is Count(Measure), you can try like this

Count(Measure)/Count(TOTAL <TPName> Measure)

and make sure that relative is unchecked on the expressions tab for this expression.

Re: line chart display %

vinieme12 — Sat, 26 Nov 2016 12:02:38 GMT

Have you check Static Min,Static Max values in the Axes tab?

How can the Chart scale DOWN to 5% when one of your dimension values is upto 33%

Re: line chart display %

Sat, 26 Nov 2016 16:58:46 GMT

Thanks Sunny and Vineet. Here is the sample QVW.

Re: line chart display %

Sat, 26 Nov 2016 20:50:25 GMT

Please see this sample QVW

Re: line chart display %

sunny_talwar — Sat, 26 Nov 2016 21:58:00 GMT

May be this?

sum(Units)/Sum(TOTAL <TPName> {<Code={'992Z2','992Z4'}>}Units)

Re: line chart display %

Sat, 26 Nov 2016 23:55:38 GMT

Thanks Sunny. This works in the chart, but this does not display in the graph,.I want the graph to display 38%, 62% curve for this TPName all the time, not just when I select this TPName.