topic Re: Need Help on Expressions and Dimension in QlikView

Need Help on Expressions and Dimension

Fri, 18 Oct 2013 08:48:49 GMT

Hi,

Dimension is : Gender

Expression: Count(members)

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

Unknown:1179+4(1183)

Male:1218

Female:3222

Any suggestions please

kaushiknsolanki — Fri, 18 Oct 2013 08:52:20 GMT

Hi,

Try this calculated expression.

If(istext(Gender),Gender),null())

Regards,

Kaushik Solanki

tresB — Fri, 18 Oct 2013 08:54:08 GMT

Use calculated dimension something like:

If(IsNull(Gender) or Gender='Null' or Gender='-', 'Unknown' , Gender)

salto — Fri, 18 Oct 2013 08:54:49 GMT

Hello,

or maybe this other one as well:

if(isnull(Gender),'Gender is Null', Gender) as Gender

Hope this helps.

Anonymous — Fri, 18 Oct 2013 08:59:35 GMT

Poornima

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