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

Get the difference of dimensions

Hello I am facing a problem to find the difference or varience between two  values of same dimension.

My application data is this:

 1.JPGNote: Here FYQ means Quarter.

First I want Quarter Report which I get by using this data.

2.JPG

Now I want a table that shows the difference of FYQ-2 and FYQ-1  and so on.

Means if I select FYQ-x and FYQ-y in the Dimension then It shows me the difference FYQ-(y-x).

 

Thanks

SG

Labels (2)
3 Replies
sunny_talwar

So, you plan to select two months or are you going to select on the quarter? If you select quarter, what would the calculation be as there are three months in both the quarter? Also... what is your current expression? and what is your dimension in the chart?
avinashelite

Could you please share the sample file or the dimensions and expression you have wrote 

RishabhTFC
Contributor III
Contributor III
Author

I want to select two-quarter FYQ-1 and FYQ-1 and each quarter has 3 months. In measures I use set analysis that subtract the value of fyq-2  to fyq-1 but that is not automated I want that in future if I select fyq-3 and fyq-2 them it automatically subtract fyq-3 to fyq-2 and so on.

thats is my problem what should I add in dimension right now the there is no dimension it is "Getcurrentselection()"