Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
How about:
=if(order_flag = 1, Count(DISTINCT order_id), Null())
Thanks,
Carlos
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
Thanks everyone for such quick responses
Used the set analysis suggested by swuehl.
Appreciate your help
Thanks swuehl for your help.
used the set analysis.
I still new to qlikview and get stuck in many simple things.
Jaya
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,