topic Right expression? in QlikView

Right expression?

Tue, 04 Mar 2014 14:47:35 GMT

Hi,

I have a column Product with values Soaps Dove, Soaps Caramel, Soaps Lux, Soaps Santhoor, Detergents XX,Detergents YY,Detergents DDFDG .

I would need to show the count of IDs which will start only with Soaps in dimension

I tried using below

Dimension: =IF(WildMatch(Product,'Soaps*'),Product)

Expression: Count(Distinct(ID))

But I doubt whether the expression is correct or not could anyone suggest me.

Thanks.

Re: Right expression?

m_woolf — Tue, 04 Mar 2014 14:50:56 GMT

Try:

count(distinct {<Product = {'Soaps*'}>}ID)

Re: Right expression?

Tue, 04 Mar 2014 14:54:19 GMT

Thanks. It is showing 'Error in calculated condition'. sorry if I am wrong.I don't want to change expression instead want to change dimension.

Re: Right expression?

jonathandienst — Tue, 04 Mar 2014 14:54:38 GMT

You could just use Product as the dimension and Count({<Product={"Soaps*"}>} Distinct ID) as the expression. For the dimension, set the checkbox for suppress nulls.

HTH

Jonathan

Edit: I try to avoid calculated dimensions where possible. This is a case that will perform better with a fixed dimension and a filtered expression.

Re: Right expression?

Tue, 04 Mar 2014 14:57:13 GMT

Thanks. Can I use this as dimension

=If(WildMatch(Product,'Soaps*'),Product)

Re: Right expression?

Tue, 04 Mar 2014 15:02:16 GMT

Thanks.