Masteritem dimension in measure

[MJansen]

Hi everyone,

I'm still quite new to Qlik Sense and I have a question that I can't figure out. Hopefully one of you.

I have created a master item dimension: =if(Wildmatch(Artikel,'*VTGM*') and not Wildmatch(Omschrijving,'*handheld*'), '1','0') and I want this dimension integrate in some tables where I want to exclude the 1 and only see the 0.

I have a structure overview in Qlik with the following formula: count({< Afnemer -= {'IG - Intern gebruik', 'Geen'}, Mutatietypecode={'34','30'}, IsExterneAfnemer={'0'},Magazijncode={'xx'}, Afnemercode-={'RCAR','RCHI','RLON','RONC'}, Omschrijving-={"*Handheld*"}>} ArtikelVerloopID).

So I want to add the master item dimension in this query, but it doesn't works for me because it looks at 2 filters at the same time in the samen field, so 'Artikel' searches all articles that contain 'VTGM' and of those that contain 'Omschrijving' 'handheld'.

Do you understand what I mean? Hopefully you have a solution.

[Or]

I don't quite understand what it is you're asking.

However, if you want to exclude certain data from your table, why not write that directly into your measure? This would typically be done using:

Count({< Regular Set Here > -  <Stuff I want to Exclude Here>} SomeField)

See: https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysi...

https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysi...