Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

Table only not working fine when current month no data.

Hi All

Table 1 working fine for last 5 year. with out any issue.

But then every month first few day , it will have some trouble. Ref to table 2 ,

notice that 2016 only have Jan & Feb sales. But Table 1 display March sales = Rm122k ,

but actually it is Feb sales ref to table 2, When March data come in Table issue will solve,

Table 1 issue will be resolve when march data come in next few day.

May i know it there any solution ?

Paul

4 Replies
deepaktibhe
Valued Contributor

Re: Table only not working fine when current month no data.

after supressing null values ur all values are disappearing in a chart

paulyeo11
Valued Contributor II

Re: Table only not working fine when current month no data.

Hi Deepak

I try to supressing null values on Table 1 dimension , but the march sales still display there.

Paul

vsudhakar
Contributor III

Re: Table only not working fine when current month no data.

you create the fiscal year calendar may be your problem is sloved

paulyeo11
Valued Contributor II

Re: Table only not working fine when current month no data.

Hi Vsudhakar

So you mean i try to make the label display change , not to display march , but the fact is now is march.

Or your suggestion is i change the expression , don't use month_n approach ? instead using SET analysis ?


Am i right ?


Paul

Community Browser