topic Re: How to create actions for in QlikView

How to create actions for

Wed, 22 Jun 2016 07:39:51 GMT

Hi Experts,

I have vendor table with Vendor,vendor status,Vendor status having values active and null values.i want dispaly any sheet object with yes,no.if we click on no i need to get only Active vendors,if clik on yes i need to get all values of vendor.

Thanks,

Siva

Re: How to create actions for

varshavig12 — Wed, 22 Jun 2016 08:43:48 GMT

Use list box with expression

Re: How to create actions for

beck_bakytbek — Wed, 22 Jun 2016 08:43:50 GMT

hi siva,

do you want the tabrows with your objects, any tabrows contain Information of vendor(active) and another tabrows with vendors (with null)

if select vendor (active), then you have only Sheets with active vendors, and if you select no then you have vendors with nulls.

did i understand right?

beck

Re: How to create actions for

varshavig12 — Wed, 22 Jun 2016 08:47:16 GMT

if(vendor_status='active','no','yes')

Re: How to create actions for

Wed, 22 Jun 2016 08:53:53 GMT

If i clik No Button i have to show all Active sattus vendor,if clik Yes i want see all the Vendors.

Thanks

siva

Re: How to create actions for

Wed, 22 Jun 2016 08:54:40 GMT

If i clik No Button i have to show all Active sattus vendor,if clik Yes i want see all the Vendors.

Re: How to create actions for

beck_bakytbek — Wed, 22 Jun 2016 09:04:18 GMT

sive,

can you give your example-data, so i can create for you an example.

beck

Re: How to create actions for

susovan — Wed, 22 Jun 2016 09:20:09 GMT

Hi Siva,

Try this attachment,

Re: How to create actions for

Wed, 22 Jun 2016 09:21:10 GMT

Vendor	Vendor_Status
1	A
2
3
4
5
6
7	A
8
9
10
11
12	A
13
14
15
16
17
18
19
20	A
21
22
23
24
25
26
27
28
29
30	A
31
32
33
34
35
36
37
38
39
40	A
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72	A
73
74
75
76
77
78
79	A
80
81
82
83
84
85
86	A
87
88
89
90
91	A
92
93
94
95
96
97
98
99
100	A
101
102
103
104
105

Re: How to create actions for

Wed, 22 Jun 2016 09:25:16 GMT

Hi Beck,

I want to create 2 buttons YES and NO,If Clik on NO i have to show all the active items,if i clik the YES i have to show all the vendors.

Thanks

siva

Re: How to create actions for

Wed, 22 Jun 2016 09:27:09 GMT

Can you please share the QVW.

Thanks

siva

Re: How to create actions for

varshavig12 — Wed, 22 Jun 2016 09:35:04 GMT

Do you want something like this:

*** When you click on 'Yes' only active vendors

*** When you Click on 'No' all vendors

Note: 'Yes' automatically gets selected.

if you want something like this

make use of two list box

list box 1:

=if(Status='active' or Status='not active' or Status='','no')

list box 2:

=if(Status='active','yes')

Re: How to create actions for

varshavig12 — Wed, 22 Jun 2016 09:36:38 GMT

Can you please post your expression ?

I cannot open this qvw.

Re: How to create actions for

Wed, 22 Jun 2016 09:47:03 GMT

How we can get yes and no keywords it's showing error.

thanks

Re: How to create actions for

Anil_Babu_Samineni — Wed, 22 Jun 2016 09:54:31 GMT

Try this,

Re: How to create actions for

Wed, 22 Jun 2016 10:05:03 GMT

What i have try ?

No information available...

Re: How to create actions for

sampada0810 — Wed, 22 Jun 2016 10:21:05 GMT

You can use conditional show/hide

Re: How to create actions for

susovan — Wed, 22 Jun 2016 10:34:20 GMT

Hi Varsha,

Try this expression,

=Only({<[Vendor Status]={'active'},Status={'No'}>}[Vendor Status])

Re: How to create actions for

varshavig12 — Wed, 22 Jun 2016 11:07:47 GMT

Sample app with Yes and NO

Re: How to create actions for

Anil_Babu_Samineni — Wed, 22 Jun 2016 11:08:48 GMT

Did you check my Attachment?