topic Cyclic calendar dimension set on time variables in QlikView

Cyclic calendar dimension set on time variables

canmarroig — Wed, 30 Sep 2015 09:32:45 GMT

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

Re: Cyclic calendar dimension set on time variables

Gysbert_Wassenaar — Thu, 01 Oct 2015 06:02:23 GMT

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

Re: Cyclic calendar dimension set on time variables

canmarroig — Thu, 01 Oct 2015 07:42:41 GMT

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

Re: Cyclic calendar dimension set on time variables

Gysbert_Wassenaar — Thu, 01 Oct 2015 12:30:18 GMT

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.

Re: Cyclic calendar dimension set on time variables

hic — Fri, 02 Oct 2015 13:38:56 GMT

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

Re: Cyclic calendar dimension set on time variables

canmarroig — Thu, 15 Oct 2015 11:28:35 GMT

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