Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

kavita25
Valued Contributor

How to show top 2 Ytd wise.. with 2 dimension..

Hi, I want to show top 4 in line chart.. where my dimension is Month & Competitor.. YTD, QTD wise on selection.

For e.g :

 

MonthNameValue
AprA100
MayA200
JunA102
JulA120
AugA140
SepA130
OctA80
AprB150
MayB300
JunB105
JulB120
AugB150
SepB230
OctB180
AprC200
MayC400
JunC360
JulC120
AugC520
SepC230
OctC165

Line Chart has two dimension Month & Name.

Expresssion is : Sum (Value ) / Sum (total Value)

For A will be : 100/450 as the % in the chart..and same for others.

Now I want YTD i.e if I select Jun then it should give for A

Sum of value for A  402 and total value is 1917...

On the basis of YTD, QTD i want top 2...

3 Replies

Re: How to show top 2 Ytd wise.. with 2 dimension..

Are you looking for top 2 or top 4?

Also, assuming you are looking for top 2, are you looking for top 2 names?

kavita25
Valued Contributor

Re: How to show top 2 Ytd wise.. with 2 dimension..

Top 2 names..

Re: How to show top 2 Ytd wise.. with 2 dimension..

I am still not sure what you are looking to get, but may be this

Capture.PNG

Community Browser