topic help me on this expression in QlikView

help me on this expression

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

Hi everyone,

I have a requirement on line chart in Qlikview/Qliksense, Please find the below attachment

>by defalut it has to show Sum(Vol)....(if no selections made)

>If I select any brand it has to show 2lines

one line with Sum(act) and another line with Sum(fore)

I have created two saparate line charts with Sum(Vol) and another line chart with Valuelist.

But I want to show both requirements in single line chart(to put both expressions in single line chart) based on these conditions.

I have tried with Getselections but not working.

Dim1: Year

Dim2: If(GetSelectedCount(Brand)=0,brand,ValueList('_Act', '_Fore'))

If(GetSelectedCount(Brand)=0, Sum(Vol), Pick(Match(ValueList('_Act', '_Fore'), '_Act','_Fore'), Sum(act),Sum(fore)) .

Any suggestions will be appreciated.

Please help me out in this.

passionate — Fri, 20 Apr 2018 15:19:39 GMT

Can you use GetSelectedCount in Qliksense?

passionate — Fri, 20 Apr 2018 15:26:11 GMT

PFA
Qlikview document

satishqlik — Fri, 20 Apr 2018 18:18:30 GMT

Thanks for response.

can you paste the script the here as am using personal edition.

passionate — Sat, 21 Apr 2018 06:15:49 GMT

Please refer attached screen shots for expressions

satishqlik — Mon, 23 Apr 2018 07:59:25 GMT

Hi Sorry for my late response.

This is what exactly am looking for

But in Qliksense how do we accomplish this requirement.

Thanks again!!