topic Expressions - right formula in QlikView

Expressions - right formula

Wed, 10 Oct 2012 11:39:36 GMT

Hello again,

this is my "formula":

Count(DISTINCT{<[Klasa artikla]={A}>} {<[Klasa artikla]={B}>} {<[Klasa artikla]={C}>} {<[Klasa artikla]={D}>} {<[Predgrupa artikla]={000}>}if(WildMatch(COMMISSSALESGROUP,KOM), ITEMID))

The marked is a series of numbers 000 - 999. Is there a possibility, to include in this formula a range?

1. Look at all "Predgrupa artikla" between 000 and 499

2. Exclude all "Predgrupa artikla" between 000 and 499

Thank you all for your help.

Re: Expressions - right formula

Miguel_Angel_Baeyens — Wed, 10 Oct 2012 11:45:50 GMT

Hi,

Yes, if the values are numeric this should work:

Count(DISTINCT{< [Klasa artikla] = {'A', 'B', 'C', 'D'}, [Predgrupa artikla] -= {">=000<=499"} >} if(WildMatch(COMMISSSALESGROUP, KOM), ITEMID))

That will use the set formed by values A-D in Klasa artikla and values not between 000 and 499.

Hope that helps.

Miguel

Re: Expressions - right formula

Wed, 10 Oct 2012 11:49:15 GMT

I love you 😃

Thank you very much.