topic Re: Need help for set analysis in QlikView

Need help for set analysis

agni_gold — Sat, 29 Nov 2014 18:57:55 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.

Re: Need help for set analysis

gidon500 — Sat, 29 Nov 2014 19:07:23 GMT

can you clarify your aouput

what you want to show on excel sheet

gidon

Re: Need help for set analysis

agni_gold — Sat, 29 Nov 2014 19:14:00 GMT

i just want to show the sum of the ID values in text box in dashboard

Re: Need help for set analysis

Anonymous — Sat, 29 Nov 2014 19:23:11 GMT

Hi Agnivesh,

Data doesn't match between the Site_ID columns in Site and Pump_Group tabs in excel sheet.

Please clarify which tab values are right.

Regards

Neetha

Re: Need help for set analysis

agni_gold — Sat, 29 Nov 2014 19:26:01 GMT

this data is sample data prepared by me

please check with question

thank u

Re: Need help for set analysis

jpenuliar — Sat, 29 Nov 2014 20:10:23 GMT

Hi,

Have a look if the image attached helpful.

Re: Need help for set analysis

Anonymous — Sat, 29 Nov 2014 20:19:54 GMT

Hi Agnivesh,

add below line in script:

if((len(trim(PUMP_GROUP_ID)))<> '0',1,0)as PumpGroup

Like this:

LOAD PUMP_ID,

SITE_ID,

PUMP_NAME,

PUMP_GROUP_ID,

if((len(trim(PUMP_GROUP_ID)))<> '0',1,0)as PumpGroup

FROM

(ooxml, embedded labels, table is Pump)

and in text box:

=count({<PumpGroup = {'1'} >}PUMP_NAME)

Regards

Neetha