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

When Dimension = Year , Expression Day can display 365 , How to make when Dimension = YearMonth , Days display 30 days ?

Hi All

I have below expression from sunny :-


If(Month(Date(Max({<sales = {'>0'}>}Date))) = 12, 365, ((Month(Date(Max({<sales = {'>0'}>}Date))) + 0) * 30))

Above work fine , when dimension = YEAR. ( Table 1 ).

When i change my dimension to YearMonth , i want Days display 30 days. ( Table 2 )

Hope some one can advise me how to achieve this ?

Paul

1 Reply
paulyeo11
Master
Master
Author

My QVF Doc