if(Wildmatch) with exclusion of some values

[#1]

Hey people,

I have got a question concerning the Wildmatch-function one can use in Qlikview.

I have a dimension called "group" with different groups:

group1, group2, group3, group4, group5

each group has got values (dimension "value"):

group1 = value11, value12, value13

group2 = value21, value22

group3 = value31, value32, value33

...

I only want to see group1, group2 and group3

So I am using the following calculated dimension which works fine:

=if(Wildmatch(group,'group1','group2', 'group3'),group)

Problem:

there are certain values in some groups I do NOT want to show. Eg. I only want to see:

group1 = value11, but NOT value12, nor value 13

group2 = everything can be shown

group3 = value32, value33, but NOT value31

Should I be using an expression with " -= " somewhere? How can I split up the wildmatch to talk about the underlying values?

Thanks a lot!

Zzzzipke

[CELAMBARASAN]

Have a Group as dimension.

Expression as

Sum({<group={'group1'}, value={'value11'}>} Sales) + Sum({<group={'group2'}>} Sales) + Sum({<group={'group3'}, value-={'value31'}>} Sales)

Hope that helps

[#3]

Thanks for your reply.

How can I add this to my -already quiet complex- expression I am using?

Sum({<measure={'kilogram'}>}Number) + Sum({<measure-={'kilogram'}>}Revenue)

Basically each value has got a measure.

And for different measures, you calculate something different.

[#4 · Accepted solution]

Try

Sum({<measure={'kilogram'},group1-={'value12','value13'},group3-={'value31'}>} Number) + Sum({<measure-={'kilogram'}>}Revenue)

[#5]

Unfortunately it does not do anything..

Everything after the first "group1-={}" is underlinded in red, eventhough it says the expression is OK.

The "values" you wrote inbetween brackets are not linked directly to the groups. I may have not explained myself very well.

The "values x" belong to another dimenion named "value".

I guess we can only select the specific values with value-={'value12', 'value13'}? Right? Because group-={value11} is not linked?

How do I solve this issue?

Thankss

[#6]

The red underline is a bug in Qlikview. The syntax highlighter does not understand extended set analysis. As long as it says the expression is OK you're good to go.

With the schema this way you can use value-={'value12', 'value13'} the way you 'say

[#7]

Yes it does work!

I came here with my own suggestion to let you adapt it because it did not work. But I have two expression and I forgot to add the ' -= value{} ' part in the other expression.

Thanks a bunch guys!!