topic Re: Action in a Text Box in QlikView

Action in a Text Box

ishika00730 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Action in a Text Box

swuehl — Fri, 16 Mar 2018 08:48:47 GMT

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?

Re: Action in a Text Box

YoussefBelloum — Fri, 16 Mar 2018 08:49:46 GMT

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

Re: Action in a Text Box

shiveshsingh — Fri, 16 Mar 2018 08:59:57 GMT

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

Re: Action in a Text Box

Qrishna — Sat, 17 Mar 2018 09:54:43 GMT

Check the attached.

Re: Action in a Text Box

ishika00730 — Wed, 21 Mar 2018 07:00:13 GMT

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

Re: Action in a Text Box

ishika00730 — Wed, 21 Mar 2018 07:05:32 GMT

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

Re: Action in a Text Box

ishika00730 — Wed, 21 Mar 2018 07:06:27 GMT

I want to show a union of above condition.

Thanks

Ishika