
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi try this one ,
COUNT({<verd_del -={'Dk'}, age = {'17','16','15','14'}>} item)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi try this one ,
COUNT({<verd_del -={'Dk'}, age = {'17','16','15','14'}>} item)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
just be aware Qlikview doesn't recognize it as right (it shows expression failure) but it works

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
COUNT({<verd_del -= {'Dk'}, age = {'17','16','15','14'}>} item)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try This
COUNT({<verd_del={"*"}-verd_del= {'Dk'}, age = {'17','16','15','14'}>} item)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nice!
