Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
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)

djlagaffe
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
Creator II
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 II
Contributor II

Nice!