Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI ,
i need to write case statement in qliksense for below statement
CASE WHEN column_name IN ('A-Dallas', 'A-Texas') THEN 'US' end
I tried in qliksense as below, which throwed error and displayed nothing
if(wildmatch([ column_name],'A*', 'US'))
Can anyone please help
You have incorrect positioning of the parenthesis
This is incorrect
If(WildMatch([ column_name],'A*', 'US'))
Try this instead
If(WildMatch([ column_name],'A*'), 'US')
Hi,
Please try
if(WildMatch([column_name],'A*')=1,'US')
You have incorrect positioning of the parenthesis
This is incorrect
If(WildMatch([ column_name],'A*', 'US'))
Try this instead
If(WildMatch([ column_name],'A*'), 'US')
How can i deal with blank values
when i have blank i need to get as '1' if have some value then '0'
hi
How can i deal with blank values
when i have blank i need to get as '1' if have some value then '0'
can you please help on this
Use Len(Trim()).... for example
If(Len(Trim(FieldName)) = 0, 1, 0) as Flag
Hi
it is throwing error
Did you replace Fieldname with your own field?
yes
i used as this
If(Len(Trim(column_name)) = 0, 1, 0)
Can you post a screenshot of the error message?