topic Re: How use only function in QlikView

How use only function

wossenhh — Mon, 12 May 2014 17:05:08 GMT

Hi,

I have a pivot chart that shows the following table:

Employee	Client	YTD Hours
John	A	10
Merry	B	15
Jim	C	25
Bob	D	35
Ron	E	55

How can I display on a pivot chart only client B, D and E with their results?

Thanks,

Wossen

Re: How use only function

mikecrengland — Mon, 12 May 2014 17:10:13 GMT

You can put it in your set analysis...

Sum(({<Client={'B','D','E'}>} [YTD Hours])

mike

www.fortunecookiebi.com

Re: How use only function

Clever_Anjos — Mon, 12 May 2014 17:13:40 GMT

You can use a calculated dimension

if(Match(Client,'B','D','E'),Client)

and check "Supress when value is null"

Re: How use only function

Mon, 12 May 2014 17:22:34 GMT

The most optimized I can think of is create a flag on the back-end and use that flag on the front-end instead of trying to use expressions on the front-end.

Its just a general suggestion to try to move as much as possible to the back-end where it will be pre-calculated and wont impact performance.

Hope attached is of some help.

Thanks

Re: How use only function

Anonymous — Mon, 12 May 2014 17:22:47 GMT

Clever,

I think in calculated dimension you have to use aggr():

aggr(if(Match(Client,'B','D','E'),Client), Client)

Re: How use only function

gouthamkk — Mon, 12 May 2014 17:33:12 GMT

Hi,

Try this, for client dimension. select add calculated dimension and place below condition

if (client='B' or 'D' or 'E', Client , null())

and then in the same tab "Suppress when value is null".

Note : Make sure you select the dimension above and check the below once.

Re: How use only function

wossenhh — Mon, 12 May 2014 18:58:26 GMT

Thanks AJ for your advise and for the attachment. It works well and you are right it is better to work from script!

Best,

Wossen

Re: Re: How use only function

Clever_Anjos — Mon, 12 May 2014 23:23:48 GMT

Not strictly necessary, PFA