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

Table only not working fine when current month no data.

paulyeo11 — Wed, 02 Mar 2016 06:09:14 GMT

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

deepakqlikview_123 — Wed, 02 Mar 2016 06:44:10 GMT

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

paulyeo11 — Wed, 02 Mar 2016 07:02:35 GMT

Hi Deepak

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

Paul

Anonymous — Wed, 02 Mar 2016 07:13:51 GMT

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

paulyeo11 — Wed, 02 Mar 2016 07:29:01 GMT

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