Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need Help on Expressions and Dimension

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

     Error.jpg

Any suggestions please

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Use calculated dimension something like:

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

View solution in original post

4 Replies
kaushiknsolanki
Luminary Alumni
Luminary Alumni

Hi,

     Try this calculated expression.

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

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
tresesco
MVP
MVP

Use calculated dimension something like:

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

View solution in original post

salto
Specialist II
Specialist II

Hello,

or maybe this other one as well:

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

Hope this helps.

bill_markham

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