Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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") 😉