Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Arnec
Contributor III
Contributor III

Filters don't add up

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.

Labels (3)
1 Solution

Accepted Solutions
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Try building your Year and Month dimensions at script level:

clipboard_image_0.png

Refer qvw attached for reference.

Thanks and regards,

Arthur Fong

View solution in original post

4 Replies
tresesco
MVP
MVP

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

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Try building your Year and Month dimensions at script level:

clipboard_image_0.png

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
Contributor III
Contributor III

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