Discussion Board for collaboration related to QlikView App Development.
Dimension is : Gender
The problem is Gender has values like M,F,-,Null.
I have to combine the values for "-" and "Null" i,e 1179+4 should be my total count for unknown Gender.
My output should be something like
Any suggestions please
Use calculated dimension something like:
If(IsNull(Gender) or Gender='Null' or Gender='-', 'Unknown' , Gender)
View solution in original post
Try this calculated expression.
or maybe this other one as well:
if(isnull(Gender),'Gender is Null', Gender) as Gender
Hope this helps.
You take Kuausik's suggested expression back to the load script and do something like:
If ( istext ( Gender), Gender , 'Unknown' ) as Gender
Best Regards, Bill