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')
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
it is throwing error
Did you replace Fieldname with your own field?
i used as this
If(Len(Trim(column_name)) = 0, 1, 0)
Can you post a screenshot of the error message?
i am getting as
no more error log is there
where can i see error log in detail
can you please help
Where are you doing this? Script or front end?
front end, while creating a sheet i am trying to write case statement, when have data for column1 as blank i should see as 1 if not 2
Can you show a screenshot of the expression in expression editor in that case?
Retrieving data ...