topic Re: Needed Set Analysis in QlikView

Needed Set Analysis

bharatkishore — Thu, 14 Jul 2016 17:32:09 GMT

Hi All,

I m using a guage chart and i have fields as Source_type and Month.

Now i needed an set analysis expression to write if(Source_Type=Non-Paid and target_month =[Data As of],Generated_Leads).

Attached excel for more info

Kindly help

Re: Needed Set Analysis

Anil_Babu_Samineni — Thu, 14 Jul 2016 17:38:18 GMT

From this Excel, What are you expecting. Which is the Expression you are applied?

Can you please post a sample application which demonstrates the problem and let me know expecting o/p

In excel, you have 3 sheets. Which sheet you want to use

Re: Needed Set Analysis

Thu, 14 Jul 2016 17:42:27 GMT

for a best performance i sugest create a flag on scrip for use on set analisys

=Count({<Source_type={"Non-Paid"},flag={1}>} [Generated Leads(LeadHub)])

script

LOAD Market,

Brand,

Channel,

Source_type,

Month,

[Generated Leads(LeadHub)],

[Target Leads],

[Data As Of],

if([Data As Of]=Month,1) as flag

FROM

(ooxml, embedded labels, table is [Vs Target Paid_non Paid_Other]);

Re: Needed Set Analysis

bharatkishore — Thu, 14 Jul 2016 17:47:32 GMT

Hi Anil,

Please find the attached excel and the qvw.

In the excel we have source_type,channel,dataasof,

Now i need to write an expression as if(sour_type=Non-Paid,Channel=Corporate and Target_month=Dataasof , sum(generated leads)

so which should show 9175 and total is 76266

Re: Needed Set Analysis

bharatkishore — Thu, 14 Jul 2016 17:49:25 GMT

Thanks a lot.. but please tell me why we have written flag, and if i want to include one more field i.e. channel = corporate what i need to write in ur expression

=Count({<Source_type={"Non-Paid"},flag={1}>} [Generated Leads(LeadHub)])

Re: Needed Set Analysis

Thu, 14 Jul 2016 17:59:53 GMT

sum({<Source_type={"Non-Paid"},Channel={"Corporate"},flag={1}>} generated leads)

Your perfomance stay beter because your informacio are calculate. You can too calculate direcly on set, but i think its not good.

Re: Needed Set Analysis

bharatkishore — Thu, 14 Jul 2016 18:03:11 GMT

Thank u so much...