topic Re: Problem with Set Analysis in QlikView

Problem with Set Analysis

bimala0507 — Mon, 04 May 2015 03:06:41 GMT

Hi Experts:

Can anyone say me, what is wrong with Below expression

if(id1=1,num(sum({$<Year_F_SHIP_DATE={$(=max(Factory_Assesment_Year))}>}[Qty (Pcs)]), '#,##0'),if (id1=0,num(sum({$<Year_B_SHIP_DATE={$(=max(Factory_Assesment_Year))}>}[Qty (Pcs)]), '#,##0')))

Here Factory_Assesment_Year is the Year, what user Select

And Year_F_SHIP_DATE is what the Year, I would like to compare with

Appreciate your immediate attention

Kind Regards,

Bimala

Re: Problem with Set Analysis

danieloberbilli — Mon, 04 May 2015 03:26:12 GMT

Why do you consider it as wrong? What result do you get and what result are you aiming for? Do you use it in the script, as a dynamic dimension or as a expression?

Re: Problem with Set Analysis

PrashantSangle — Mon, 04 May 2015 03:44:21 GMT

Hi,

Try with "" double quote

try below

if(id1=1,num(sum({$<Year_F_SHIP_DATE={"$(=max(Factory_Assesment_Year))"}>}[Qty (Pcs)]), '#,##0'),

if (id1=0,num(sum({$<Year_B_SHIP_DATE={"$(=max(Factory_Assesment_Year))"}>}[Qty (Pcs)]), '#,##0')))

Regards,

Re: Problem with Set Analysis

Mon, 04 May 2015 04:02:07 GMT

Your expression should contain single quote '

as follows:

{'$(=max(Factory_Assesment_Year))'}

and you have

{$(=max(Factory_Assesment_Year))}

Question : Why you use Max ?, is it because a user can select more than one Year and you are trying to select just the top value of the possible selection?.

Regards,

Re: Problem with Set Analysis

ToniKautto — Mon, 04 May 2015 04:07:29 GMT

The answer to your question will depend on what your data looks like, and what you are trying to do. A correct syntax does not guarantee the calculated result is as expected.

Please provide a sample application with data and details on what results you expect.