topic Re: VARIABLE ISSUE in QlikView

VARIABLE ISSUE

Tue, 03 Nov 2015 01:22:30 GMT

I created a variable (vMonthToday) = Month(Today()), which I was using in Set analysis in one of my charts. It was in production for almost 8 Months now and never had issues with it.

I also recalling the variable in Text box like ($(vMonthToday)) and no results.

All of a sudden that variable is not working now I never touched that dashboard . I just noticed it today. The chart works fine If I remove that variable from there.

Can that be a BUG???

Below is the part of the expression.

count({< Year = {$(vYearToday)}, Month = {$(vMonthToday)}

Re: VARIABLE ISSUE

jagan — Tue, 03 Nov 2015 02:13:37 GMT

HI,

What is the expression for vYearToday and vMonthToday? Is any date format changed in the backend (database/flat files)? Generally this is the reason for this.

Regards,

Jagan.

Re: VARIABLE ISSUE

SreeniJD — Tue, 03 Nov 2015 03:23:21 GMT

Its certainly not a bug. Check whether the variables are still available variable in Settings->Variable OverView..

Alternatively you can check whether this function is giving results in your Test Box object..

=Month(Now())&Year(Now())

Sreeni