Skip to main content
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!