topic Re: Alternate state object with show condition in QlikView

Alternate state object with show condition

Mon, 17 Nov 2014 09:29:18 GMT

Hi,

I wanted to use an alternate state for an object with conditional show. When implementing it the object with the alternate states they are being hidden. I don't the exact reason for this behaviour. The condition that has been used is

=only(sales)='USA'

Re: Alternate state object with show condition

sujeetsingh — Mon, 17 Nov 2014 09:31:26 GMT

can you post a sample

Try using

=if(sales='USA',1,0)

Re: Alternate state object with show condition

Mon, 17 Nov 2014 12:40:35 GMT

No it's not working, Any condition used in layout tab makes the alternate state object to appear in all the states.

the required output is if my sales is America then, it should display the alternate state object

Re: Alternate state object with show condition

tresB — Mon, 17 Nov 2014 12:48:28 GMT

GetFieldSelection() has now(possibly from SR8 onwards) got one parameter to allow alternate state. Hence, upgrade (if required) qv and try the function.

Re: Alternate state object with show condition

Mon, 17 Nov 2014 12:57:39 GMT

You mean that I need to upgrade my Qlikview version(right now I am using SR6) and then it works using GetFieldSelection(), to get the desired result.