Discussion board where members can get started with Qlik Sense.
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:
Load * inline
transactionMonth, Month, Quarter, QuarterMonth
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.
You will also need one more field associated with your data is 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.
If possible share sample app.