topic Re: Set Analysis in QlikView

Set Analysis

Fri, 26 Feb 2016 21:17:59 GMT

Hi All,

Can someone tell me what's wrong with the below formula.

=(Sum({[BookRev]<QuarterNum={"$(=Max({$}QuarterNum))"}, [DimYear] ={"$(=Max({$}[DimYear]))"}>} grossamount)

Sum({[BookRev]<QuarterNum={"$(=If(Max({$}QuarterNum) - 1 = 0, 4, Max({$}QuarterNum)-1))"}, [DimYear] ={"$(=If(Max({$}QuarterNum) - 1 = 0, Max({$}[DimYear]) - 1, Max({$}[DimYear])))"}>} grossamount) * 4

Sum({[BookCost]<QuarterNum={"$(=If(Max({$}QuarterNum) - 1 = 0, 4, Max({$}QuarterNum)-1))"}, [DimYear] ={"$(=If(Max({$}QuarterNum) - 1 = 0, Max({$}[DimYear]) - 1, Max({$}[DimYear])))"}>} grossamount))

When I apply these formulas separately they all work, once I put all of these together in one formula it only gives me the value for the first part (the one in the orange).

Thanks in Advance,

Re: Set Analysis

swuehl — Fri, 26 Feb 2016 21:26:48 GMT

Could you upload a small sample QVW that demonstrates the issue?

It's hard to tell what's wrong without knowing the context.

Re: Set Analysis

Fri, 26 Feb 2016 21:32:16 GMT

Please find attached the sample sheet.

Re: Set Analysis

sunny_talwar — Fri, 26 Feb 2016 21:45:20 GMT

What is the output you are hoping for? With and without selections?

Re: Set Analysis

swuehl — Fri, 26 Feb 2016 21:45:27 GMT

You essentially calculate something like

A - B/C

You don't get just A, but B/C results in a number much smaller than A, that's why you think you only get A.

Maybe you want to calculate

(A-B ) / C

Then just add parentheses accordingly.

Re: Set Analysis

Fri, 26 Feb 2016 21:57:26 GMT

Thanks Stephen for you help