Sort by expression or calculated dimension?

Wed, 19 Dec 2012 17:20:55 GMT

Hi!

I'm quite new to QlickView, and I'm unable to find how to sort by expression or to create a relevant calculated dimension to do it.

My data are the following one: I have a pivot table listing some fields used in an IT system for many banks, and not all banks use the same fields. I would like, for each field, have a column indicating if each bank uses it or not, and at the end count how many banks use it.

I was able to either use a calculated dimension or an expression to flag if each bank use it (value 1, calculated this way:

=if(BU_PUBLIC_CLASS='X',1,0)

I was able to have the sum with the following expression:

TOTAL_VISIB=sum(if(BU_PUBLIC_CLASS='X',1,0)+if(BDL_LU_CLASS='X',1,0)+if(BDL_BE_CLASS='X',1,0)+if(CIC_CH_CLASS='X',1,0)+if(BTB_CLASS='X',1,0)+if(BTL_CLASS='X',1,0)+if(CIC_SG_CLASS

='X',1,0))

but how can I select only the OBJ_CLASS_ID whose TOTAL_VISIB > 0? I want to be able to do a dropdown select if possible...

Thank you very much for your help!

topic Sort by expression or calculated dimension? in QlikView

Sort by expression or calculated dimension?