Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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
Partner

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
Partner

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

marcus_sommer
MVP & Luminary
MVP & Luminary

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.