Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
RishabhTFC
Contributor III
Contributor III

Alternate State Differences

Hello I am using alternate state in qlik sense and I have a query.

I have two columns one is of month and their respective values.

MonthProfit
1-Apr-1820000
1-May-1835000
1-Jun-1869000
1-Jul-1815000
1-Aug-1839000
1-Sep-1878000

 

So I want to make an app in the qlik sense that uses the alternate states to find the difference between two selected months.

Suppose if I select Jun in State-1  and select Aug in State-2  then it subtracts the profit of Aug to Profit of Jun and shows the respective result e.g: State-1 .

Just like in below picture:

Capture.JPG

Help me to create this app 

thanks

SG

Labels (2)
2 Replies
marcus_malinow
Partner - Specialist III
Partner - Specialist III

Maybe something like this - substitute in your state names

sum({State1} Profit) - sum({State2} Profit) 

qlikpritamdeb
Contributor II
Contributor II