Set expression with { }

[TomBond77]

Hi experts

I need your help.

I have the following set expression:  Count({<Year={'2021'}, Material={''}>} [PO Number])

But I need the opposite of Material={''} - I need all material values except the material without value.

Any ideas?

Thank you

Tom

[kaushiknsolanki]

Hi, to get all the values except the one which is defined you should use not equal to like shown below.

Count({<Year={'2021'}, Material-={''}>} [PO Number])

It is nothing but adding the minus sign '-' before '=' sign.

[TomBond77]

Thank you

Now I have a new challenge: Your solution which works for the first scenario, should also work for this set expression. But is not working. Do you have any ideas? I need to rank the bottom 10 in QlikSense:

rank(-Sum({<Year={'2021'},Material-={''}>} [Days Leadtime] - [PLIFZ-Days]) /
count([PO Number]))

Many Thanks for your help.