topic Re: showing selected value in the straight table in QlikView

showing selected value in the straight table

Tue, 24 May 2016 15:36:49 GMT

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 — Tue, 24 May 2016 16:27:35 GMT

How about:

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

Thanks,

Carlos

swuehl — Tue, 24 May 2016 16:29:19 GMT

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

Alternatively, you can use set analysis

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

and as dimension just order_id_id

Tue, 24 May 2016 16:49:27 GMT

Thanks everyone for such quick responses

Used the set analysis suggested by swuehl.

Appreciate your help

Tue, 24 May 2016 16:51:01 GMT

Thanks swuehl for your help.

used the set analysis.

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

Jaya

santiago_respane — Tue, 24 May 2016 17:07:37 GMT

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,