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.
Not applicable

plz help me this its urjent

month :

jan:   weeks  (1  to 4)

feb:   weeks  (5 to 8)

march: week(9 to 12)

april  : week(13 to 16)

if  i select   month  feb       then  it showing week  no  5 to  8   week   but  i got requirement that   ...   show the  number 

  it should  show    week  5 to 8     but numbers    should  be  1 to  4  

5  :1

6:2

7:3

8:4

   

similarly   month = march

9:1

10:2

11:3

12:4

if  i select  any month   but  it  instead of that  week number it should  show 1  to 4

but the   data  should   be  corresponding   be     that  month only

1 Reply
gopalopsharma
Contributor

Re: plz help me this its urjent

Hello Karthik,

Use a mapping table somewhat like below:

MonthWeekNo.
Jan

1

1
Jan22
Jan33
Jan44
Feb51
Feb62

Hope this will help.

If not please explain the detailed context.

Community Browser