topic Multi line chart in QlikView

Multi line chart

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

Hi All,

my below range sum expression is giving all zero for line chart , and this is working perfectly in pivot table . Can please expertise suggest on this .

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

Can please someone help me on this .

Thanks in advance

Re: Multi line chart

smilingjohn — Tue, 26 Nov 2019 05:21:32 GMT

Any help expertise ???

Re: Multi line chart

smilingjohn — Tue, 26 Nov 2019 13:12:20 GMT

Any help on this

Re: Multi line chart

Anil_Babu_Samineni — Tue, 26 Nov 2019 13:31:53 GMT

May be try this for straight?

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

Re: Multi line chart

smilingjohn — Tue, 26 Nov 2019 14:21:19 GMT

Hi Anil

Thanks for th reply

How do I convert the below expression to straight . Can you please help me.on this

RangeSum(
RangeSum(Before(TOTAL Count({<Year *= {">2015"}, Status = {'OpenTicket'}>}Key) + Sum({1<Year *= {">2015"}>}0), 0, ColumnNo(TOTAL))),

-Before(TOTAL RangeSum(Before(TOTAL Count({<Year *= {">2015"}, Status = {'ClosedTicket'}>}Key) + Sum({1<Year *= {">2015"}>}0), 0, ColumnNo(TOTAL))))
)

Re: Multi line chart

Anil_Babu_Samineni — Tue, 26 Nov 2019 14:24:40 GMT

May be this

RangeSum(
RangeSum(Above(TOTAL Count({<Year *= {">2015"}, Status = {'OpenTicket'}>}Key) + Sum({1<Year *= {">2015"}>}0), 0, RowNo(TOTAL))),

-Above(TOTAL RangeSum(Above(TOTAL Count({<Year *= {">2015"}, Status = {'ClosedTicket'}>}Key) + Sum({1<Year *= {">2015"}>}0), 0, RowNo(TOTAL))))

Re: Multi line chart

Brett_Bleess — Mon, 09 Dec 2019 19:50:02 GMT

John, did Anil's last post do the trick for things? Do not forget to use the Accept as Solution button on that post if it did to give him credit for the assist and let other Community Members know that worked for the use case. If you are still working on things, leave an update.

Regards,
Brett