Solved: Re: Alternate state - Qlik Community

qv_testing · ‎2016-02-24

HI Community,

Can we use Alternate state in Layout Condition..???

Suppose i have 2 Alternate Selections, If i am select 2 States i want to display 3 chart..

Is any possibility??

Thanks

settu_periasamy · ‎2016-02-24

Hi,

May be the alternate (Not sure working for you )

=Rangesum(if(not isnull(Only({G1}DivisionName)),1),
if(not isnull(Only({G1}Category)),1),
if(not isnull(Only({G1}ProductName)),1))>0 and

Rangesum(if(not isnull(Only({G2}DivisionName)),1),
if(not isnull(Only({G2}Category)),1),
if(not isnull(Only({G2}ProductName)),1)) >0

View solution in original post

sunny_talwar · ‎2016-02-24

If you select 2 States? How are you planning on making a selection in Alternate State? Or do you mean to make selection in fields within different states? Please elaborate so that we can help you better

qv_testing · ‎2016-02-24

Exactly..

I have 2 different state selections..

if i am select these 2 states, i want to display 3 chart.. depends on these 2 state selections..

Hope you understand...

sunny_talwar · ‎2016-02-24

How are you selecting states is my question? Can you share a sample where you doing this?

qv_testing · ‎2016-02-24

!Hi Sunny,

PFA,

Thanks

sunny_talwar · ‎2016-02-24

Try this condition:

(GetSelectedCount(DivisionName, False(), 'G1') + GetSelectedCount(Category, False(), 'G1') + GetSelectedCount(ProductName, False(), 'G1') > 0) and

(GetSelectedCount(DivisionName, False(), 'G2') + GetSelectedCount(Category, False(), 'G2') + GetSelectedCount(ProductName, False(), 'G2') > 0)

qv_testing · ‎2016-02-24

It's not working..

Expression showing Error

sunny_talwar · ‎2016-02-24

Have you looked at the attached qvw file? It isn't working for you?

Saravanan_Desingh · ‎2016-02-24

I learnt something today. Elegant piece of code Sunny.

qv_testing · ‎2016-02-24

In Application also not working,

See attached Image..