Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Master
Master

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

My QVF Doc