Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
paulyeo11
Valued Contributor II

How to make Column 4 display number of day of the month ?

Hi All

How to make column DAY display

30 when i click month= Jan.

60 when i click month= Feb.

Now i fill in 60 , it is not flexible

Paul.

1 Solution

Accepted Solutions

Re: How to make Column 4 display number of day of the month ?

what if you use this:

=month*30

when your month = 1, the expression will give 30 and when its 2, it will give your 60 and so on..

Best,

Sunny

3 Replies

Re: How to make Column 4 display number of day of the month ?

what if you use this:

=month*30

when your month = 1, the expression will give 30 and when its 2, it will give your 60 and so on..

Best,

Sunny

Re: How to make Column 4 display number of day of the month ?

PFA the qvw

paulyeo11
Valued Contributor II

Re: How to make Column 4 display number of day of the month ?

Hi Sir

Thank you , it work fine.

Paul

Community Browser