showing selected value in the straight table

[#1]

Hello All,

I want to show all the order_id's where the order_flag is 1 in straight table.

I tried giving below expression but it didnt work

count(Distinct If(order_flag = 1, order_id_id, Null())

Please help me with this.

Thanks & Regards,

Jaya

[clondono]

How about:

=if(order_flag = 1, Count(DISTINCT order_id), Null())

Thanks,

Carlos

[swuehl · Accepted solution]

You can use a calculated dimension

=If(order_flag = 1, order_id_id)

and suppress NULL on dimension tab

Uncheck 'suppress zero values' on presentation tab or use an expression

=1

Alternatively, you can use set analysis

=Sum({<order_flag ={1}>} 1)

and as dimension just order_id_id

[#4]

Thanks everyone for such quick responses

Used the set analysis suggested by swuehl.

Appreciate your help

[#5]

Thanks swuehl for your help.

used the set analysis.

I still new to qlikview and get stuck in many simple things.

Jaya

[santiago_respane]

Hi,

i would go with set analysis, something like this:

=Count({<order_flag ={1}> DISTINCT order_id_id}

=Sum({<order_flag ={1}>} 1)

Hope this helps.

Kind regards,