Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
ganeshreddy
Contributor III

Drill down not working.

Hi All,

I got an issue here, drill down for total equipment(Last metric) in first table is not working. That expression contains complex set expression. help me to rectify this. Please find attached QVW.

Regards,

Ganesh.

4 Replies
MVP
MVP

Re: Drill down not working.

I think you need to resolve the current fields from dimension group in the advanced aggregation and maybe use the set expression also on the outer aggregation:

sum({<EquipmentGroupName=,EquipmentClassName=,EquipmentCategoryName=,EquipmentModelName=>}

aggr(

Count({<EquipmentGroupName=,EquipmentClassName=,EquipmentCategoryName=,EquipmentModelName=>}

          distinct EquipmentId)

,$(=GetCurrentField( Organization ))

)

)

ganeshreddy
Contributor III

Re: Drill down not working.

Hi MarcoWedel

Nice to see you after long time in my post, please help me on this issue.

Best Regards,

Ganesh.

ganeshreddy
Contributor III

Re: Drill down not working.

Hi Swuehl,

thanks for the reply, I tried this already but its not working. Here total equipment in both table should match, not happening in this case. Do I have to make any changes in data model? please help me here.

Best regard,

Ganesh.

ganeshreddy
Contributor III

Re: Drill down not working.

Hi Swuehl,

I tried to put that get current field logic in condition for that expression, it is not working. have you got any idea on this.

Best Regards,

Ganesh