Comparing Selected Quarter vs Prior Quarter ?

[bob654321]

I have 3 listboxes year, month and quarter. How can I compare the selected quarter with the prior quarter  when a year and quarter are selected from the listboxes ? Similarly when I select the year and month listboxes, it should compare the months of the selected year vs months of the previous year. Similarly for Year selection.

Here is my measure. Count(distinct id).

The output pivot table should look like this

Metric   2019-Q3  2019-Q2

                     3                  4

                     2                   5

[anushree1]

Please check https://community.qlik.com/t5/QlikView-Documents/QlikView-App-Set-Analysis-Prior-Period-Comparison/t...

[bob654321]

Thanks! I didn't see anything for quarter comparison in the qvw.  I would really appreciate if you can show me how to write one expression to display the quarter comparison.

[tresesco]

The expression would depend on how your data look like. Try to share a sample data set and explain your expected output against that.

[qliksus]

Maybe something like the below 

SUM({<Year={$(=if(getselectedcount(Quarter) , only(Year), only(Year)-1 ))},Quarter={$(=if(getselectedcount(Quarter), 'Q'& (right(Quarter,1)-1 ),'*'))} >}amount)

[bob654321]

Sorry, your expression did not work.

[Brett_Bleess]

Bob, have a look over the following Design Blog post, I think it may be helpful:

https://community.qlik.com/t5/Qlik-Design-Blog/Year-over-Year-Comparisons/ba-p/1462927

Here is the base URL in case you want to search further yourself, there are 700+ mostly how-to posts in this area that may prove quite useful.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett