Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

abhonsle
New Contributor III

Quarter-o-Quarter & Year-o-Year

Hi,

I would like to compare the data for "current quarter" vs "last quarter" and "current quarter" vs "last year quarter".

I have a inline table:

InlineMonth:

Load * inline

[

transactionMonth, Month, Quarter, QuarterMonth

1,Jan,Q1,JanQ1

2,Feb,Q1,FebQ1

3,Mar,Q1,MarQ1

4,Apr,Q2,AprQ2

5,May,Q2,MayQ2

6,Jun,Q2,JunQ2

7,Jul,Q3,JulQ3

8,Aug,Q3,AugQ3

9,Sep,Q3,SepQ3

10,Oct,Q4,OctQ4

11,Nov,Q4,NovQ4

12,Dec,Q4,DecQ4

];

the filed I would be using is the "QuarterMonth"

I would like to assign variables in my load script like  "current quarter", "Previous Quarter", "Year Ago Quarter". I am looking for an expression and then use the above variables in my dashboard.

HELP!

3 Replies
shraddha_g
Honored Contributor III

Re: Quarter-o-Quarter & Year-o-Year

You will also need one more field associated with your data is Year

abhonsle
New Contributor III

Re: Quarter-o-Quarter & Year-o-Year

I have the fields "TransactionYear" and "TransactionMonth". The "TransactionMonth" field has numbers 1,2,3,4...etc.. That is the reason I made an inline table called InlineMonth.

shraddha_g
Honored Contributor III

Re: Quarter-o-Quarter & Year-o-Year

If possible share sample app.