Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

sibin_jacob
Not applicable

Straight table expression

Hi,,

I have a straight table with 6 dimensions.At a time only one active dimension. I am using conditional enable in dimension.

My dimensions are Region,District,Territory,CITY,ZIP,Physician.

My expression for physician level

sum ({$<%Rx_AGG_Product_ID={3},Rx_AGG_Product_Name=>} Vol )

ZIP level

sum ({$<%Rx_AGG_Product_ID={3},Rx_AGG_Product_Name=,Physician=>} Vol )

City level

sum ({$<%Rx_AGG_Product_ID={3},Rx_AGG_Product_Name=Physician=,zip=>} Vol )

territory level

sum ({$<%Rx_AGG_Product_ID={3},Rx_AGG_Product_Name=,physician=,zip=,city=>} Vol )

District level

sum ({$<%Rx_AGG_Product_ID={3},Rx_AGG_Product_Name=,physician=,zip=,city=,territory=>} Vol )

Region level

sum ({$<%Rx_AGG_Product_ID={3},Rx_AGG_Product_Name=,physician=,zip=,city=,territory=,District=>} Vol )

To acheive this functionality I am using lot of if condion.

Based on condion one of the dimension get active ..

Is there any other way to get each level value ?

Thanks,

Sibin Jacob

Tags (2)