Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can anyone show me how to use the Evaluate value to do the condition like <> 0, >100, < 100 etc?
Assume have a field named "Amount" in my report, and I want to filter accordingly. thanks!
You can do it inside your application using set analysis.
sum({<Amount -= {'0'}>}Amount)
sum({<Amount = {'>100'}>}Amount)
sum({<Amount = {'<100'}>}Amount)
you can create a flag in qlik and use that in nprinting 0,1
Hi,
as usual i suggest you go first to help document, where in point 5 you have example.. Please keep in mind that evaluated formula needs to return single value.
If you want your formula to filter range of values you need to use alternatives mentioned above by other community users.
You can use QlikView and Qlik Senseformulas to calculate values to be used in filters. Each formula must return a single value and use QlikView or Qlik Sense syntax. For example, you can use a formula to calculate the value of the previous year and compare it with the Year field in a filter.
Do the following:
cheers
Lech
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
you must regenerate the cache in order to see the object in the template editor.
Did you hear about search strings and single quotes?
....Then, wildcards in strings enclosed by single quotes will no longer be considered as wildcards. Instead, the strings will be interpreted as literals, i.e. the engine will try to match the string with a field value containing the ‘*’ character. The same logic will apply also to relational operators and equals signs.
HTH - Daniel.
Hi Lech,
Thanks for the information. I checked this before, I cannot get it, so I post here.
I try to put value field as below. It all filter out all data. So I would like to check what is the correct syntax to put on the value.
="> 0"
=Amount > 0
>0
Thanks Chanty,
That's how I current workaround, but this is kind of workaround is not good, as I need to create extra fields in the App that really don't need.
Thanks Leonardo,
I know how it works on Qlik Sense, but I only want this filter on NP when I generated the report.
so the result of any formula needs to be single value. Therefore your filter like > 0 etc will not work as it may return multiple values..
Those technics need to be implemented on model side.
regards
Lech
Other alternatives are:
- create a calculated column in the chart used for reporting with the comparison formula write in order to get True or False (dingle value, you can also use 1 or 0 etc). If you want you can hide the column.
- create a calculated field in the reload script with the comparison formula. Compared with previous solution this is faster when creating reports but more rigid.
Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.