Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
smilingjohn
Contributor III

line chart...

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...

4 Replies
Highlighted
anushree1
Valued Contributor II

Re: line chart

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

Highlighted
smilingjohn
Contributor III

Re: line chart

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

 

 

 

Highlighted
smilingjohn
Contributor III

Re: line chart

Hi Any help on this 

Highlighted
smilingjohn
Contributor III

Re: line chart

Is this not possible ?