topic Re: only in QlikView

only

Fri, 09 Jan 2015 10:38:38 GMT

Hi,

What does it mean?

if(only({1} Type)='Current',green(),red())

Thanks

Re: only

Gysbert_Wassenaar — Fri, 09 Jan 2015 10:43:59 GMT

If the only possible value of Type is the string 'Current' then apply the color green, otherwise apply the color red.

Re: only

its_anandrjs — Fri, 09 Jan 2015 10:44:44 GMT

Hi,

Its means Only Type will be 'Current' and meaning of {1} is no selection will effect the expression and when equation is true will display Green() otherwise Red().

Regards

Anand

Re: only

Fri, 09 Jan 2015 10:56:42 GMT

Hi,

Something seems to be incorrect with your expression : if(only({1} Type)='Current',green(),red())

If it is used in the Color Expression, it will always return Red().

Only() - acts as a aggr expression

{1} - It will return value (here,Type) irrespective of the selection.

You might get a better explaination If you may elaborate your query !

Cheers !

Re: only

Gabriel — Fri, 09 Jan 2015 11:11:45 GMT

Hi Amit,

Without enough details and explanation it is difficult to understand what you want to achieve.

However looking at your expression, i think you want to use the expression above and probably it isn't given you the result you desire.

= IF(ONLY({1} Type ='Current',green(),red()) should only work in chart BACKGROUND COLOR. But i don't see it working anywhere else. The use on 1 disregards selections.

If you can provide more details and explanations may be you might get more help.

Best Regards,

Gabriel

Re: only

Fri, 09 Jan 2015 12:50:04 GMT

Hi Gabreil,

Thanks for your quick explanation.

I got the use of this. \

I am using it for text color and purpose is when you select one value then other values should be also having text color

HTH

Re: only

rubenmarin — Fri, 09 Jan 2015 13:11:01 GMT

Hi Amit,

The {1} ignores selection but not the dimension in graph, if "Type" is a dimension it says: If this value is for the Type 'Current' paint it green, in other case paint it red.