topic Re: Re: Re: Re: Set analysis problem in QlikView

Set analysis problem

Fri, 11 Apr 2014 08:29:55 GMT

Dear All,

I am facing problem in seta analysis.

In variable vTest2 i am storring all the growth vendor name through concat.

vTest2=Concat(DISTINCT IF(AGGR(sum( {<@_Date={">=$(vFinStartDatePY)<=$(vMonthEndPY)"},@_FinFullYear=,@_FinQuarter=,@_Month=>} #_Sales_Qty)< sum( {<@_Date={">=$(vFinStartDateCY)<=$(vMonthEndCY)"},@_FinFullYear=,@_FinQuarter=,@_Month=>} #_Sales_Qty),CUSPARTYNAME),CUSPARTYNAME),',')

I have to write a expression for sum of the sale quantity for growth vendor.

Expression :-

=sum({$<@_Date={">=$(vFinStartDateCY)<=$(vMonthEndCY)"},@_FinFullYear=,@_FinQuarter=,@_Month=,CUSPARTYNAME={'$(vTest2)'}>} #_Sales_Qty)

sum({$<@_Date={">=$(vFinStartDatePY)<=$(vMonthEndPY)"},@_FinFullYear=,@_FinQuarter=,@_Month=,CUSPARTYNAME={'$(vTest2)'}>} #_Sales_Qty)

Means how much is the growth quantity from previous Year.

But its not working.

Please need your help.

Regards,

Sukamal

Re: Set analysis problem

tresB — Fri, 11 Apr 2014 08:34:19 GMT

I guess you are missing chr(39) in variable definition. Try to share your sample app.

Re: Set analysis problem

Fri, 11 Apr 2014 08:38:22 GMT

Its separated by ','

Re: Set analysis problem

Fri, 11 Apr 2014 08:39:30 GMT

Its a live application I can't share it.

Re: Set analysis problem

tresB — Fri, 11 Apr 2014 08:41:43 GMT

Preparing examples for Upload - Reduction and D... | Qlik Community

Re: Set analysis problem

tresB — Fri, 11 Apr 2014 08:44:10 GMT

It's fine about separator, but while you have to include strings in set analysis, multiple strings should be enclosed within single quotes and separated by commas. Isn't it so?

Re: Set analysis problem

Fri, 11 Apr 2014 08:53:16 GMT

I have given sing quote in set analysis.

CUSPARTYNAME={'$(vTest2)'}

But this is not working

Re: Set analysis problem

tresB — Fri, 11 Apr 2014 09:01:27 GMT

These quotes will evaluate your variable, but the the individual strings (that would be generated in the variable) would not have those quotes. Check your variable in a textbox. It would produce output like: String1, String2. While to use in set anaysis, that should have been like: 'String1', 'String2'.

Re: Re: Set analysis problem

Fri, 11 Apr 2014 09:31:03 GMT

Hi Tresco,

I am attaching test .qvw and excel data.

Please check the app.

Re: Re: Re: Set analysis problem

tresB — Fri, 11 Apr 2014 09:41:29 GMT

Please find attached your solution.

Re: Re: Re: Re: Set analysis problem

Fri, 11 Apr 2014 09:59:19 GMT

Hi Tresco ,

I need another help.

I need not billed vendor count and previous yr qty for not billed vendor.

I modify the excel sheet.

Please check it.