Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

how to find the difference between measures of two selected bars in barchart?

example:

i want to find difference as

value in rupees in-

1984 = 43.44

1991 = 39.22

difference between them = 43.44 - 39.22 = 4.22

please help

difference example.PNG

16 Replies
Highlighted
Partner
Partner

alternative measures?

Highlighted
Contributor III
Contributor III

every charts has different states so selection of one chart is not effecting the other charts .. so in such scenario i want to show the difference in two selected points on graph

Highlighted
Partner
Partner

and that's exactly what the expression does:

Capture.PNG

Highlighted
Contributor III
Contributor III

i understood the expression but i want this baased on different states

eg:

='difference btwn '&max(Year)& ' and '& min(Year)&' ='

& (avg(<STATE1>{<Year={"$(=max(Year))"}>}(Wheat2)) - avg(<STATE1>{<Year={"$(=min(Year))"}>}(Wheat2)))

Highlighted
Partner
Partner

You're using QlikView or QlikSense?

Highlighted
Partner
Partner

if it's qlik sense, how are you creating alternate states?

Highlighted
Contributor III
Contributor III

yes it is qlik sense i used extension for that,

GitHub - ChristofSchwarz/QSExtension_SetObjectState: This Qlik Sense Extension allows you to assign ...

here's a link to that extension