topic Point in time using as dimension? in QlikView

Point in time using as dimension?

yipchunyu — Thu, 26 Mar 2020 01:12:47 GMT

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?

Re: Point in time using as dimension?

Taoufiq_Zarra — Thu, 26 Mar 2020 09:01:19 GMT

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

Re: Point in time using as dimension?

yipchunyu — Thu, 26 Mar 2020 09:03:31 GMT

sorry, so how can i create a dimension

Current YTD vs LY YTD?

Re: Point in time using as dimension?

Taoufiq_Zarra — Thu, 26 Mar 2020 09:24:01 GMT

can you share a sample data ?