Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi try this one ,
COUNT({<verd_del -={'Dk'}, age = {'17','16','15','14'}>} item)
Hi try this one ,
COUNT({<verd_del -={'Dk'}, age = {'17','16','15','14'}>} item)
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
just be aware Qlikview doesn't recognize it as right (it shows expression failure) but it works
COUNT({<verd_del -= {'Dk'}, age = {'17','16','15','14'}>} item)
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
Try This
COUNT({<verd_del={"*"}-verd_del= {'Dk'}, age = {'17','16','15','14'}>} item)
Nice!