topic Re: Need Help in Set Analysis in QlikView

Need Help in Set Analysis

agni_gold — Sat, 29 Nov 2014 16:50:09 GMT

Hi I have created the data model in which i have created the link between ZONE_Id,MAIN_ID ans SUB_ID .

but my problem is to when i select a ZONE_ID there will be selection for MAIN_ID and SUB_ID both but i want sum of the MAIN_ID but not to select the all SUB_ID who lie in MAIN_ID

But those MAIN_ID vale who dose not have any SUB_ID i also need sum of these SUB_ID

how can i do in set analysis.

Re: Need Help in Set Analysis

its_anandrjs — Sat, 29 Nov 2014 16:53:56 GMT

Can you elaborate more please with any example for this.

Regards,

Anand

Re: Need Help in Set Analysis

agni_gold — Sat, 29 Nov 2014 17:31:18 GMT

Hi I am attaching the sample data

Please check I have 4 tables

Zone

Site

Pump Group

Pump

Zone is Master if i select the zone id the corresponding sites are selected in my data model and corresponding to these site Ids Pump Group and Pumps are selected.

But the problem is here when pump group and pump are selected the i have to show in my dashboard , firstly Pump group but it is possible some pumps are lie in selected pump group so i have not to show the pumps those are lie in pump group .

But those pumps which doesn't have any pump group , i have to show in dashboard.