Discussion Board for collaboration on QlikView Scripting.
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 ?
after supressing null values ur all values are disappearing in a chart
I try to supressing null values on Table 1 dimension , but the march sales still display there.
you create the fiscal year calendar may be your problem is sloved
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 ?