topic Re: Filters don't add up in QlikView

Filters don't add up

Arnec — Sat, 16 Nov 2024 02:28:21 GMT

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.

Re: Filters don't add up

tresB — Tue, 17 Sep 2019 07:54:01 GMT

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

Re: Filters don't add up

Arthur_Fong — Tue, 17 Sep 2019 07:54:50 GMT

Try building your Year and Month dimensions at script level:

Refer qvw attached for reference.

Thanks and regards,

Arthur Fong

Re: Filters don't add up

marcus_sommer — Tue, 17 Sep 2019 07:55:26 GMT

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

Re: Filters don't add up

maxronny — Tue, 17 Sep 2019 11:29:16 GMT

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