topic Re: Set Analysis in QlikView

Set Analysis

Wed, 16 Oct 2013 11:02:22 GMT

Hi All,

Please help me convert below mentioned expression into set analysis.

Expression:

Count(if((Account_Table_ACSAT.Responded='yes' or Account_Table_ACSAT.Responded='Yes') and (Account_Table_ACSAT.Q2_Score=6 or Account_Table_ACSAT.Q2_Score=7),1))
/Count(if((Account_Table_ACSAT.Responded='yes' or Account_Table_ACSAT.Responded='Yes'),1))

Thanks in advance!

Regards,

Ankita

Re: Set Analysis

CELAMBARASAN — Wed, 16 Oct 2013 11:09:31 GMT

Hi,

Count({<Account_Table_ACSAT.Responded={'yes', 'Yes'}, Account_Table_ACSAT.Q2_Score={6, 7}>} Account_Table_ACSAT.Responded)

/ Count({<Account_Table_ACSAT.Responded={'yes', 'Yes'}>} Account_Table_ACSAT.Responded)

Re: Set Analysis

Wed, 16 Oct 2013 12:54:10 GMT

Hi,

Could you plz covert below if condition into set analysis.

Expresion:

(isnull(Count(if(Account_Table_Pulse.Responded='Yes' and (Account_Table_Pulse.Q2_Score=6 or Account_Table_Pulse.Q2_Score=7),1))/Count(if(Account_Table_Pulse.Responded='Yes',1))),0,(Count(if(Account_Table_Pulse.Responded='Yes' and (Account_Table_Pulse.Q2_Score=6 or Account_Table_Pulse.Q2_Score=7),1))/Count(if(Account_Table_Pulse.Responded='Yes',1))))

Re: Set Analysis

CELAMBARASAN — Wed, 16 Oct 2013 12:59:26 GMT

Probably this

Alt(Count({<Account_Table_Pulse.Responded={'Yes'}, Account_Table_Pulse.Q2_Score={6, 7}>} Account_Table_Pulse.Responded) / Count({<Account_Table_Pulse.Responded={'Yes'}>} Account_Table_Pulse.Responded), 0)

Re: Set Analysis

Wed, 16 Oct 2013 13:38:36 GMT

Hi,

I am getting error "Drawing of chart internally failed" when am using above expression without dimension.