Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kavita25
Partner - Specialist
Partner - Specialist

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
sunny_talwar

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
Partner - Specialist
Partner - Specialist
Author

Top 2 names..

sunny_talwar

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

Capture.PNG