Qlik Sense Comparison to previous period Set analysis

[Anonymous]

Hi,

I have hard time getting my bar chart working as I would like to. What I would like, is to have a previous period from my selections next to the bar of current selections.

The formula i have now:

Count({<[Document Timestamp.autoCalendar.InYTD]=,[Document Timestamp.autoCalendar.Month]=,

[Document Timestamp.autoCalendar.Date]={">=$(vMinDateLastPeriod)<=$(vMaxDateLastPeriod)"}>}DISTINCT Key_SessionCounter)

I have put my variables to their own KPI boxes and they work fine.

Could someone explain why my formula is not working?

[YoussefBelloum]

Hi,

Would you be able to share the expressions of your variables (vMinDateLastPeriod and vMaxDateLastPeriod) ?

[Anonymous]

Hi,

AddMonths(min(date([Document Timestamp.autoCalendar.Date])),-12) 

AddMonths(max(date([Document Timestamp.autoCalendar.Date])),-12) 

[YoussefBelloum]

Before going to the previous period, do your Actuals bars display correctly ?

for me: vMinDateLastPeriod IS OK, but vMaxDateLastPeriod is not ok. because both will be rolling 12 months back..

[sasiparupudi1]

Try

Count({<[Document Timestamp.autoCalendar.InYTD]=,[Document Timestamp.autoCalendar.Month]=,

[Document Timestamp.autoCalendar.Date]={">=$(=vMinDateLastPeriod)<=$(=vMaxDateLastPeriod)"}>}DISTINCT Key_SessionCounter)

[Anonymous]

Hi, Yes the actual bars shows correctly. But previous shows zeros.  The variables show correct dates. So if I choose 2018 the variables will give me 1.1.2017 and 31.12.2017 and that is correct. So the set analysis should count the values between those dates.

[Anonymous]

did not work   thank you anyways for trying.

[YoussefBelloum]

Would you be able to share sample QVF or attach some sample data here ?

[sasiparupudi1]

Does it return values if you hardcode the dates into set analysis?

[Anonymous]

no it does not. so maybe its a format thing?