Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
dhanavindhan
Creator
Creator

Select in Field - Search String - If conditon

Hi Experts,

I need to filter my record by using the Select in Filed -  Search String.

I created a button then set this following for my button action.

It is fully based on my Filter (SRRChargeID)

Select in field

Field: "SRRusdamt"

Search String: 0

This is working fine.

The issue i am facing now is,

Some "SRRChargeID" not having 0 in "SRRusdamt".

So while selecting that type of ChargeID as my filter it's showing me other SRRchargeID's which has 0 value.

I don't want them. It should work only for my filter based condition. If there is no 0 mean it should be blank. How to resolve this issue?

What type of "If" condition i need to write in the search string value so i can get blank if there is no 0 amt for my serach based condition.

Pls help me.

Regards,

Dhana R

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

Try this,

=If(Count({<SRRReport.usdamt={'0'}>}SRRReport.usdamt)>0,0)

View solution in original post

1 Reply
tamilarasu
Champion
Champion

Try this,

=If(Count({<SRRReport.usdamt={'0'}>}SRRReport.usdamt)>0,0)