Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

PFA for solution.

Regards,

Jagan.

View solution in original post

10 Replies
qlikmsg4u
Specialist
Specialist

Hi Abinesh,

Try this

Button > Action > Select in Field >

Field = Value

Search String = >30

Add table box with fields ID and Value

vardhancse
Specialist III
Specialist III

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.

Not applicable
Author

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

qlikmsg4u
Specialist
Specialist

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

Not applicable
Author

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

qlikmsg4u
Specialist
Specialist

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?

jagan
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

Hi

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

Not applicable
Author

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