topic Re: Based on button selection the Table value will be changed itself.... in QlikView

Based on button selection the Table value will be changed itself....

Thu, 06 Aug 2015 04:38:55 GMT

Hi to all,

I am in a problem.... I 've a table. Based on a button selection I want to show the Rollno which have the value Greater than 30.

Ref:

RollNo Value

1 20

2 35

3 40

4 30

5 25

6 50

I got my result by using this exp "=if(Value<30,RollNo).. But I need to show the result once click on button. In a First time I want to show all RollNo and Values, OnceI click on Button it show the RollNo and Value which greater than 30...

Re: Based on button selection the Table value will be changed itself....

qlikmsg4u — Thu, 06 Aug 2015 04:42:06 GMT

Hi Abinesh,

Try this

Button > Action > Select in Field >

Field = Value

Search String = >30

Add table box with fields ID and Value

Re: Based on button selection the Table value will be changed itself....

vardhancse — Thu, 06 Aug 2015 04:46:25 GMT

in table expression use variable instead of number 30

in button action mention the variable and value as 30.

Instead use input box, where we will have feasibility to give dynamic value.

Re: Based on button selection the Table value will be changed itself....

Thu, 06 Aug 2015 05:00:51 GMT

Hi guys Thanks for your reply....

Its working but if I 've field like Value1, Value2, Value3 in that case how can I fix the same problem.. Can you please help me...

Re: Based on button selection the Table value will be changed itself....

qlikmsg4u — Thu, 06 Aug 2015 05:29:32 GMT

Change the Field in Action based on your requirement to Value1 or Value2 etc

Re: Based on button selection the Table value will be changed itself....

Thu, 06 Aug 2015 05:43:58 GMT

Sorry I didn't get it can you please give some clear information about tat..

Re: Based on button selection the Table value will be changed itself....

qlikmsg4u — Thu, 06 Aug 2015 05:46:11 GMT

if you have data like this

RollNo Value Value1

1 20 23

2 35 12

3 40 34

4 30 55

5 25 66

6 50 11

change the button action to

Button > Action > Select in Field >

Field = Value1

Search String = >30

Add table box with fields ID,Value and Value1

is this you are asking for?

Re: Based on button selection the Table value will be changed itself....

jagan — Thu, 06 Aug 2015 06:46:13 GMT

Hi Abinesh,

If you attach sample file and your expected output then it would be easier to provide the solution.

Please check below link to get the correct answers quickly

Qlik Community Tip: Posting Successful Discussion Threads

Regards,

Jagan.

Re: Based on button selection the Table value will be changed itself....

Thu, 06 Aug 2015 13:15:07 GMT

Here I attached my sample file..

In that table I want to show RollNo and related date... where the Mark1 or Mark2 or Mark3 've non-zero values. And it should be show once I click a button means... On before selecting button it show the full values including Zeros also....

For further info pls contact me....

Re: Based on button selection the Table value will be changed itself....

Thu, 06 Aug 2015 13:18:04 GMT

sorry spell mistake "show rollno and related data...."

Re: Based on button selection the Table value will be changed itself....

jagan — Thu, 06 Aug 2015 15:44:22 GMT

Hi,

PFA for solution.

Regards,

Jagan.