Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
ishika00730
Contributor III
Contributor III

Action in a Text Box

Hi,

I have the below data set:

Name, Country, EMail, Preference, age

    A, BR, 1, z, 18

    B, ZZ, 1, z, 19

    C, SP, 1, z, 20

    D, JK, 1, z, 21

    E, HR, 1, z, 22

    F, BR, 1, r, 20

    G, ZZ, 1, r, 21

    H, SP, 0, r, 23

    J, JK, 1, r, 24

    I, HR, 0, r, 25

    K, BR, 1, d, 28

    L, ZZ, 1, d, 29

    M, SP, 1, d, 30

    N, JK, 1, d, 31

    O, HR, 1, d, 32

I want to set an action. The action is divided into 2 parts:

1. Age >= 18, Preference=z,r and email=1 and country=BR

2. Age >= 18, Preference=z,r,d and email=1 and country <> BR

But the requirement is to have both the action in one button. I tried to create a button through which I could fulfil age, preference and email requirement but I am not able to fulfil the last requirement of country.

Can someone suggest me how to do that. I want  to show the data in a table but as soon as I click this button these requirements have to be fulfilled.

Thanks in advance

7 Replies
swuehl
MVP
MVP

Do you want to show the UNION of the two sets described under 1. and 2.?

Or do you want to toggle between the two sets when pressing the button?

YoussefBelloum
Champion
Champion

Hi,

what is the action type you're trying to use when you say ?

1. Age >= 18, Preference=z,r and email=1 and country=BR



shiveshsingh
Master
Master

Action means? what do you want to do if these conditions are satisfied?

krishna_2644
Specialist III
Specialist III

Check the attached.

1.PNG

2.PNG

ishika00730
Contributor III
Contributor III
Author

Hi Stefan,

The requirement is to create a button which can satisfy both the above conditions. So, I want to see the data in a straight table for all the countries. It will be a full set of data but as soon as I click the button, it should show the preference as z and r for BR while for all other countries it should show the preference as z, r, d.

Is it possible to have this action in one button

ishika00730
Contributor III
Contributor III
Author

Hi Krishna,

Thanks for the response. I saw your attachment and found that when I click once, it selects BR and on 2nd click it selects the other countries. But the exact requirement is to have all the countries and other details in a straight table by default. But when you click on the button, it shows the rows with Preference=z,r for Country=BR while it shows the rows with Preference=z,r,d for other countries.

Is there any possible way we can achieve this?

Thanks

Ishika

ishika00730
Contributor III
Contributor III
Author

I want to show a union of above condition.

Thanks

Ishika