Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
Specialist II

Condition issue

Hi guys,

I have a problem with condition

I have an expression

IF([Categories]='Dislike' , 'C:\Users\Pictures\Unhappy.png',

IF([Categories]='Suggestion','C:\Pictures\Neutral.png',

IF([Categories]='Praise', 'C:\Users\Pictures\Happy.png' )))

It works, it shows the images.

But I want to add this condition

{<CleanedText_Comment={'*$(ExcludeKeyword)*'}>}

Is it possible to combine 2 conditions in 1 set analysis?

Thanks,

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

You should be able to wrap the entire thing in an Only and put the set expression there.

Only(

{<CleanedText_Comment={'*$(ExcludeKeyword)*'}>}

IF([Categories]='Dislike' , 'C:\Users\Pictures\Unhappy.png',

IF([Categories]='Suggestion','C:\Pictures\Neutral.png',

IF([Categories]='Praise', 'C:\Users\Pictures\Happy.png' )))

)

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

You should be able to wrap the entire thing in an Only and put the set expression there.

Only(

{<CleanedText_Comment={'*$(ExcludeKeyword)*'}>}

IF([Categories]='Dislike' , 'C:\Users\Pictures\Unhappy.png',

IF([Categories]='Suggestion','C:\Pictures\Neutral.png',

IF([Categories]='Praise', 'C:\Users\Pictures\Happy.png' )))

)

View solution in original post

Highlighted
Specialist II
Specialist II

Thank you, Rob