topic Re: Comparing Selected Quarter vs Prior Quarter ? in QlikView

Comparing Selected Quarter vs Prior Quarter ?

bob654321 — Sat, 16 Nov 2024 19:20:24 GMT

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

Re: Comparing Selected Quarter vs Prior Quarter ?

anushree1 — Thu, 09 Jan 2020 06:57:23 GMT

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

Re: Comparing Selected Quarter vs Prior Quarter ?

bob654321 — Thu, 09 Jan 2020 07:01:33 GMT

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.

Re: Comparing Selected Quarter vs Prior Quarter ?

tresB — Thu, 09 Jan 2020 07:27:49 GMT

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

Re: Comparing Selected Quarter vs Prior Quarter ?

qliksus — Fri, 10 Jan 2020 04:37:16 GMT

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)

Re: Comparing Selected Quarter vs Prior Quarter ?

bob654321 — Fri, 10 Jan 2020 04:57:30 GMT

Sorry, your expression did not work.

Re: Comparing Selected Quarter vs Prior Quarter ?

Brett_Bleess — Mon, 10 Feb 2020 20:21:37 GMT

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