Current Quarter and Previous quarter Creation

[chmahi7033]

I created current quarter variable based on today() date but I don't wont this logic.

Any one could help me how create current quarter based on quarter field(Q1-19,Q2-19,Q3-19,Q4-19).

[Brett_Bleess]

Best I have is the following Design Blog link on Set Analysis, you may actually want the 'Dates' related post that is a link at the bottom of the following one:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Here is the base URL to the Design Blog area in case you want to do some further searching on your own:

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

You may need to look at the Master Calendar post potentially or Canonical Calendar post too...

Regards,
Brett

[Chanty4u]

try this

vCurrent_Quarter=   Quarter={"$(=GetFieldSelections(Quarter))"}

vPrevious_Quarter = Quarter={"$(=GetFieldSelections(Quarter)-1)"}

sum({<$(=vCurrent_Quarterr)>}Sales)

sum({<$(=vvPrevious_Quarter)>}Sales)