topic Re: Calculated dimension in QlikView

Calculated dimension

ecabanas — Tue, 28 Apr 2015 15:58:23 GMT

Hi I have a table like this:

salesid sales

pv001 10

pv002 20

pv991 10

and salesid as a Dimension, but I only want to see the salesid that begins by "PV00" not PV9

Many thank's

Eduard

Re: Calculated dimension

ramoncova06 — Tue, 28 Apr 2015 16:09:32 GMT

try this

sum( {$<salesid ={"pv0*"}>} sales )

Re: Calculated dimension

ecabanas — Tue, 28 Apr 2015 16:33:46 GMT

Hi Ramon,

I did this, but when you select one from the list did not works, The selecction did not works. I would like do the filter via Dimension not via Expression

Many thank's

Eduard

Re: Calculated dimension

sunny_talwar — Tue, 28 Apr 2015 16:39:57 GMT

Try this as your calculated dimension:

If(WildMatch(salesid, 'pv0*'), salesid) and don't forget to check suppress null values

Best,

Sunny

Re: Calculated dimension

ramoncova06 — Tue, 28 Apr 2015 16:41:48 GMT

are your sales id upper or lower case ?

to do this in the dimension you have to do the following if(left(salesid,3) <> 'PV9', salesid) then select excluded null values

though I would still suggest to try to get the expression to work since you tend to get better performance

Re: Calculated dimension

sunny_talwar — Tue, 28 Apr 2015 16:43:56 GMT

I agree with Ramon Covarrubias‌. Its better to have the expression do the job for you unless you have 50 expressions and repeating the same condition is going to be painful.

Best,

Sunny

Re: Calculated dimension

jaimeaguilar — Tue, 28 Apr 2015 17:33:41 GMT

Hi,

you can use this expression:

=if(wildmatch(salesid, 'PV00*'), salesid, null() ) and check the option "suppress value when null",

regards

Re: Calculated dimension

ecabanas — Wed, 29 Apr 2015 07:46:30 GMT

Hi Ramon,

The Dexpression works fine, but what happens when I want to exclude the PV9 and PVR ?

Many many thank's to all to help to me

Eduard

Re: Calculated dimension

amit_saini — Wed, 29 Apr 2015 07:52:23 GMT

Hi,

try:

=if(Left(salesid, 4) = 'PV00', salesid)

Thanks,
AS