Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. 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