topic Re: not able to add two set analysis expression in QlikView

not able to add two set analysis expression

ferha_jafri — Tue, 08 Oct 2013 08:41:01 GMT

Hello Everyone,

I have an issue as i am not able to add two set analysis expression for one dimension eg.

sum({<year={2003}>}sales)+sum({<year={2004}sales>})

Re: not able to add two set analysis expression

MK_QSL — Tue, 08 Oct 2013 08:45:06 GMT

try

SUM({<Year = {'2003','2004'}>}sales)

Re: not able to add two set analysis expression

Tue, 08 Oct 2013 08:45:36 GMT

Sum({<Year={'2003','2004'}>}Sales)

Re: not able to add two set analysis expression

Tue, 08 Oct 2013 08:45:46 GMT

Hello,

There is a error in your formula, try this :

sum({<year={2003}>}sales)+sum({<year={2004}>} sales)

But if you want a set analysis with several values for the same dimension, you should write this :

sum({<year={2003, 2004}>}sales)

Re: not able to add two set analysis expression

fdelacal — Tue, 08 Oct 2013 08:46:24 GMT

you can do it that.

sum({<year={'2003','2004'}>}sales)

Re: not able to add two set analysis expression

senpradip007 — Tue, 08 Oct 2013 08:50:39 GMT

Hi Ferha,

Your expression is wrong. The Correct one is as follows:

Sum({$<Year={'2003'}>} sales) + Sum({$<Year={'2004'}>} sales)

But as you are using set analysis, you must use like

Sum({$<Year={'2003','2004'}>} sales) which is more authentic.

Re: not able to add two set analysis expression

Tue, 08 Oct 2013 08:51:57 GMT

Dear Sir/Madam,

Thank you for your E-mail. We may or may not have received your mail. Please forward the same mail to my new mail id hitesh.makwana@goapl.com again.

Kindly update your address book for future communications.

Rgds,

Hitesh Makwana

022, 42187749

Re: not able to add two set analysis expression

ferha_jafri — Tue, 08 Oct 2013 11:20:35 GMT

the exact expression is

if([Brand Description]='AERRANE (ISOLFURANE 250 ML)', if(Currency='INR',

SUM({<YearMonth={$(vCurrentYearMonth)},[Invoice Date]={'<=$(vCYTDDate)'},Zone={'India','North','South'},[Product Code]={'IN2L9101'}>}[Net Sales Amt]),

SUM({<YearMonth={$(vCurrentYearMonth)},[Invoice Date]={'<=$(vCYTDDate)'},Zone={'India','North','South'},[Product Code]={'IN2L9101'}>}[Net Sales Amt]/$(vConversionRate)))/1000,

if([Brand Description]='ISOFLURANE USP 100ML', if(Currency='INR',

SUM({<YearMonth={$(vCurrentYearMonth)},[Invoice Date]={'<=$(vCYTDDate)'},Zone={'India','North','South'},[Product Code]={'IN2L9100'}>}[Net Sales Amt]),

SUM({<YearMonth={$(vCurrentYearMonth)},[Invoice Date]={'<=$(vCYTDDate)'},Zone={'India','North','South'},[Product Code]={'IN2L9100'}>}[Net Sales Amt]/$(vConversionRate)))/1000,

if([Brand Description]='ISOFLURANE-100ML',(if(Currency='INR',

SUM({<YearMonth={$(vCurrentYearMonth)},[Invoice Date]={'<=$(vCYTDDate)'},Zone={'India','North','South'},[Product Code]={'IN2L9101'}>}[Net Sales Amt]),

SUM({<YearMonth={$(vCurrentYearMonth)},[Invoice Date]={'<=$(vCYTDDate)'},Zone={'India','North','South'},[Product Code]={'IN2L9101'}>}[Net Sales Amt]/$(vConversionRate)))/1000

+if(Currency='INR',

SUM({<YearMonth={$(vCurrentYearMonth)},[Invoice Date]={'<=$(vCYTDDate)'},Zone={'India','North','South'},[Product Code]={'IN2L9100'}>}[Net Sales Amt]),

SUM({<YearMonth={$(vCurrentYearMonth)},[Invoice Date]={'<=$(vCYTDDate)'},Zone={'India','North','South'},[Product Code]={'IN2L9100'}>}[Net Sales Amt]/$(vConversionRate)))/1000))))

and i am not able to get the sum.

Re: not able to add two set analysis expression

Tue, 08 Oct 2013 11:21:21 GMT

Dear Sir/Madam,

Thank you for your E-mail. We may or may not have received your mail. Please forward the same mail to my new mail id hitesh.makwana@goapl.com again.

Kindly update your address book for future communications.

Rgds,

Hitesh Makwana

022, 42187749

Re: not able to add two set analysis expression

MK_QSL — Tue, 08 Oct 2013 11:39:36 GMT

Try like this <=$(=vCYTDDate)

Re: not able to add two set analysis expression

qlikpahadi07 — Tue, 08 Oct 2013 11:56:00 GMT

ferha_jafri

Sorry Ferha I can't thing we can help you with this expression ... try to upload a Demo instead will be helpful

Re: not able to add two set analysis expression

Tue, 08 Oct 2013 11:57:22 GMT

Dear Sir/Madam,

Thank you for your E-mail. We may or may not have received your mail. Please forward the same mail to my new mail id hitesh.makwana@goapl.com again.

Kindly update your address book for future communications.

Rgds,

Hitesh Makwana

022, 42187749