Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Valued Contributor II

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
Valued Contributor II

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

My QVF Doc