Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Nagaraju_KCS
Specialist III
Specialist III

Alternate state

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

Labels (1)
1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

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

22 Replies
sunny_talwar
MVP
MVP

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

Nagaraju_KCS
Specialist III
Specialist III
Author

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
MVP
MVP

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

Nagaraju_KCS
Specialist III
Specialist III
Author

!Hi Sunny,

PFA,

Thanks

sunny_talwar
MVP
MVP

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)

Nagaraju_KCS
Specialist III
Specialist III
Author

It's not working..

Expression showing Error

sunny_talwar
MVP
MVP

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

Saravanan_Desingh
MVP
MVP

I learnt something today. Elegant piece of code Sunny.

Nagaraju_KCS
Specialist III
Specialist III
Author

In Application also not working,

See attached Image..

Capture.JPG