Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

CASE statement in QlikSense

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

13 Replies
Anonymous
Not applicable
Author

i am getting as

error

Invalid dimension

no more error log is there

where can i see error log in detail

can you please help

sunny_talwar

Where are you doing this? Script or front end?

Anonymous
Not applicable
Author

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

sunny_talwar

Can you show a screenshot of the expression in expression editor in that case?