Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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
deepakqlikview_123
Specialist
Specialist

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

paulyeo11
Master
Master
Author

Hi Deepak

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

Paul

Anonymous
Not applicable

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

paulyeo11
Master
Master
Author

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