Discussion Board for collaboration related to Creating Analytics for QlikView.
As a part of my expession I have used
My problem is, when I chose more than half of my months instead of returning jan, feb, mar ...(the selected) then the sting return NOT(Aug, sep,)
So if I aske if the substringcount includes January, and I have selcted everything else but January, then the expression will still tel me, that January is a selcted value.
Is there an easy way to correct this?
Go to Solution.
You could also try something like this:
If(Left(GetFieldSelections(Month), 3) = 'NOT',
If(SubStringCount(GetFieldSelections(Month),'Jan') = 0,
... Does not contain Jan in NOT form ...
... Contains Jan in normal form ...
Hope that helps
Have you tried increasing the number of items that GetFieldSelections returns?
getfieldselections ( Month, ',' , 12 )
It dit not do any changes
A lot of if's, but usefull
Weird, works fine for me in QV10.
I'm also i QV10