Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have below values i want to exclude 'High' related values using set analysis. WE use Qliksense
Field
Energy - High - 18/3/2023
Energy - Low - 18/3/2023
I have tried using below expression, but it is not working.
count({<Field -={'*High*'}>} sales)
Please help.
I found the solution. We need to use DOUBLE QUOTES around the value in set analysis.
count({<Field -={"*High*"}>} sales)
count({<Field -={'High'}>} sales)
'High' is a single word in the value(as you can see in the example above). So not sure if it works.
I found the solution. We need to use DOUBLE QUOTES around the value in set analysis.
count({<Field -={"*High*"}>} sales)
Ah. That wasn't quite clear to me, sorry.
count({<Field -={"*High*"}>} sales)
Double quotes are necessary to treat the string as a search string rather than a direct match.