Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
yipchunyu
Creator
Creator

Point in time using as dimension?

I created a master calendar and setup some variable which prepared for using point in time reporting 
PeriodID = {$(=Max(PeriodID) – 12)}, Year = , Quarter = , Month = , Period =
QuarterID = {$(=Max(QuarterID) – 4)}, Year = , Quarter = , Month = , Period =

 

It works when I use it in measure, like below:

=Sum(${<=$(vSetPreviousQuarter)>} [SALES_USD])

However, I want to use the variable in chart as dimension.

In other words, is it possible to make 

Current YTD vs LY YTD in the x-axis of a bar chart?

3 Replies
Taoufiq_Zarra

you can fill nothing in dimension and leave the expressions with these values!


if not the expressions in dimension without aggr , I don't see very well

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
yipchunyu
Creator
Creator
Author

sorry, so how can i create a dimension 

Current YTD vs LY YTD?

Taoufiq_Zarra

can you share a sample data ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉