Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
i have the "year" column
2019,2020,2021..etc
i have the "monthnum" column
1,2,3,4...etc
and also the "weeknum" column
1,2,3,...etc
I need a variable which concatenate year + (Monthnum or weeknum) depending on what the user like to see.
How can i achieve this?
The common way is to have a date within the fact-table which is then linked to a master-calendar which could contain as many period-fields as you need and in which way they are needed - strings + numeric and/or as dual() values. Important: as far as you need a <= or >= comparing or any kind of min/max-calculation or similar stuff the values needs to be numeric or dual. More background could you find here:
How to use - Master-Calendar and Date-Values - Qlik Community - 1495741
- Marcus
Maybe with something like: makedate(year, monthnum) as date
- Marcus
I tried but it doesnt solve my problem.
The user define if he want to see "weekly" or "monthly view" via a variable that "expand" the dimension
or "Weekly"
any tips?
The common way is to have a date within the fact-table which is then linked to a master-calendar which could contain as many period-fields as you need and in which way they are needed - strings + numeric and/or as dual() values. Important: as far as you need a <= or >= comparing or any kind of min/max-calculation or similar stuff the values needs to be numeric or dual. More background could you find here:
How to use - Master-Calendar and Date-Values - Qlik Community - 1495741
- Marcus