Cyclic calendar dimension set on time variables

[canmarroig]

Hi i've to show some numbers on a dashboard (I use text box), in order to show a count(ID_order) choosing differerent calendars (order date, activation date, etc) on different period (vthismonth, vpreviousmonth, vthismonththisyear or vthismonthpreviousyear, etc).

I've tried with this expression:

count({<[vCalendar]={'$(vThisMonth)'}>}ID_Order) but I've no results, what's my mystake?

Tks

[Gysbert_Wassenaar]

Make sure that the value in the period variables like vThisMonth has the same date format as the calendar fields. See this blog post: Dates in Set Analysis

[canmarroig]

Thank you but i've already checked, it's the same format, if I change the cyclic dimension in one of his order_date or activation date, etc:

count({<[order date]={'$(vThisMonth)'}>}ID_Order) or

count({<[activation date]={'$(vThisMonth)'}>}ID_Order)

it's ok. Thanks

[Gysbert_Wassenaar · Accepted solution]

Check that your variable vCalendar contains the correct case senstive field name. The construction you posted works fine here. Perhaps you can post a small qlikview document that demonstrates the problem.

[hic]

In your expression

   count({<[vCalendar]={'$(vThisMonth)'}>}ID_Order)

the vCalendar is interpreted as a field reference, which of course will not work. Instead, you should use a dollar expansion:

   count({<[$(vCalendar)]={'$(vThisMonth)'}>}ID_Order)

HIC

[canmarroig]

Gysbert i've made a mistake in vCalendar since i confused two different kind of dates, thank you