topic Re: line chart in QlikView

line chart...

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi Expertise,

I have two dimension ,Severity and Week and expression has rangesum and this work perfectly in a pivot table .
But when i try to convert this a Line chart it doesn't work .
Can you please suggest what needs to be done to get this ?

DImension
Severity
Week

Expression :
rangeSum(Before(TOTAL Count({<Year*={">2015"},
Status-={'Bolt','Trifor','Hexa','Nexon'}>}ID)+Sum({1<Year=P(Year)>}0), 0,ColumnNo(TOTAL)))

Any help on this

Thanks in Advance...

Re: line chart

anushree1 — Mon, 25 Nov 2019 06:11:14 GMT

Please try :

rangeSum(above(TOTAL Count({<Year*={">2015"},
Status-={'Bolt','Trifor','Hexa','Nexon'}>}ID)+Sum({1<Year=P(Year)>}0), 0,rowno(TOTAL)))

It would be better to get a sample to check the issue

Re: line chart

smilingjohn — Mon, 25 Nov 2019 06:52:45 GMT

Hi I cant use rangesum(above formula ,

As i am using weekly data as shown in the attachment , in a pivot table i have made the Weekly date horizontal on top and department vertical therefore i have cumulative column wise , and the expression i shared in my pivot table is giving accurate result . But this is not working in Line charts .

Below expression used in pivot table :

rangeSum(Before(TOTAL Count({<Year*={">2015"},
Status-={'Bolt','Trifor','Hexa','Nexon'}>}ID)+Sum({1<Year=P(Year)>}0), 0,ColumnNo(TOTAL)))

Thanks in Advance

Re: line chart

smilingjohn — Mon, 25 Nov 2019 09:00:18 GMT

Hi Any help on this

Re: line chart

smilingjohn — Mon, 25 Nov 2019 11:25:56 GMT

Is this not possible ?