Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using <> as different from in Set analysis doesnt work?


I´m trying to use <> as different from in a Set Analysis but get error in expression set modifier

COUNT({<verd_del <> {'Dk'}, age = {'17','16','15','14'}>} item)

How du I do this? 

1 Solution

Accepted Solutions
mambi
Creator III
Creator III

Hi try this one ,

COUNT({<verd_del -={'Dk'}, age = {'17','16','15','14'}>} item)

View solution in original post

7 Replies
mambi
Creator III
Creator III

Hi try this one ,

COUNT({<verd_del -={'Dk'}, age = {'17','16','15','14'}>} item)

struniger
Creator
Creator

Try -= instead of <>

Here's a cool tool for set analyses:

http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=

Best regards

Stefan

bumin
Partner - Creator II
Partner - Creator II

just be aware Qlikview doesn't recognize it as right (it shows expression failure) but it works

MK_QSL
MVP
MVP

COUNT({<verd_del -= {'Dk'}, age = {'17','16','15','14'}>} item)

aveeeeeee7en
Specialist III
Specialist III

Dear Soren

Set Analysis does not support <>

In Set Analysis  Not equal to is represented by '-='

Your Expression should be:

COUNT(${<verd_del-={'Dk'}, age = {'17','16','15','14'}>} item)

Regards

Aviral Nag

sunilkumarqv
Specialist II
Specialist II


Try This

COUNT({<verd_del={"*"}-verd_del= {'Dk'}, age = {'17','16','15','14'}>} item)



BryanFontes
Contributor III
Contributor III

Nice!