Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Hi Abinesh,
Try this
Button > Action > Select in Field >
Field = Value
Search String = >30
Add table box with fields ID and Value
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.
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...
Change the Field in Action based on your requirement to Value1 or Value2 etc
Sorry I didn't get it can you please give some clear information about tat..
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?
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.
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....
sorry spell mistake "show rollno and related data...."