topic Re: decoding a expression in QlikView

decoding a expression

Anonymous — Tue, 13 May 2014 10:34:40 GMT

Hi Experts,

I am using this expression in Background color definantion of Expression tab

what it does when some of the product types are selected in list box only they are highlighted

while other are grayed out , I want to know how this expression work ??

if(not match(only({1} [Product Type]),

$(=concat(distinct chr(39) & [Product Type] & chr(39) , ' , ' ))) , argb(200,200,200,200) )

anant

Re: decoding a expression

vadimtsushko — Tue, 13 May 2014 12:36:05 GMT

I believe best way to decode complex expression is to evaluate its less complex parts in same context.

I suppose you have chart with [Product type] as one of dimension listbox for selection in [Product type], and some expression in chart made unrelated from [Product type]?

If so - file in attachment shows how it works.

By the way in that case I would use less complex conditional, something like this:

If(not only({1} [Product Type]) = only(TOTAL [Product Type]),ARGB(200,200,200,200))

Re: decoding a expression

Roop — Tue, 13 May 2014 12:49:20 GMT

Vadim was almost there ... Thanks Vadim!

To get all of them highlighted and not just single values:

if(len(Only([Product Type])) > 0,

ARGB(200,200,200,200),

null()

)

Re: decoding a expression

vadimtsushko — Tue, 13 May 2014 12:56:26 GMT

I respectfully disagree

Mine is working. Have you tried yours? You can try it in my file.

Re: decoding a expression

vadimtsushko — Tue, 13 May 2014 13:01:46 GMT

Variation of your formula do the trick perfectly. And it is very simple too

if(IsNull(Only([Product Type])), ARGB(200,200,200,200))

Thank you that is much better then my variant.