Filters don't add up

[Arnec]

I created a dashboard that will show our margins and turnovers based on dates and customer groups. I currently have 3 listboxes:

• Year (based on the year of the creation date)
• Month (based on the month of the creation date - same field as above)
• Customer Group

Currently I'm able to combine year or month with customer group but I can't seem to make a selection of all 3 fields. Qlik will toggle of one of the date fields. How can i solve this? I've attached the QVW.

[tresesco]

Create year and month fields in the script and use them in list box

[Arthur_Fong · Accepted solution]

Try building your Year and Month dimensions at script level:

Refer qvw attached for reference.

Thanks and regards,

Arthur Fong

[marcus_sommer]

Best practice is not to create year/month within listbox expression else to create those fields as native fields within a master-calendar in the script - with it your wanted selections will work.

- Marcus

[maxronny]

Must Create year and month fields when you edit the script. after it, you can select these new fields in the selection.