topic Re: Discrete QTRs data to be added in App Development

Discrete QTRs data to be added

alis2063 — Fri, 15 Nov 2024 20:54:17 GMT

Need to subtract the current value from previous value in Set Analysis

below is Actual value & expected output against the quarters

Quarter	Value	Expected Output
Q1	30	30
Q2	90	60
Q3	120	30
Q4	180	60

Regards,

Ali

Re: Discrete QTRs data to be added

marksouzacosta — Thu, 25 Jul 2024 04:07:22 GMT

Hi @alis2063,

You don't need Set Analysis. You can do this changing your Load Script. See the code below:

TempData:
LOAD * INLINE [
Quarter,Value
Q1,30
Q2,90
Q3,120
Q4,180
];

Data:
LOAD
    Quarter,
    Value,
    Value - Alt(Peek(Value),0) AS Expected
RESIDENT
	TempData
ORDER BY
	Quarter
;

DROP TABLE TempData;

Re: Discrete QTRs data to be added

alis2063 — Thu, 25 Jul 2024 12:09:03 GMT

Can't we do this in set analysis

Re: Discrete QTRs data to be added

marksouzacosta — Thu, 25 Jul 2024 16:33:19 GMT

hi @alis2063,

Maybe it is possible to do using Set Analysis, but Qlik have other features to better handle this scenario.
For a chart table for example you can use the Above function:

Sum(Value) - Alt(Above(Sum(Value)),0)

Where are you trying to use that expression?

Re: Discrete QTRs data to be added

alis2063 — Tue, 06 Aug 2024 10:55:44 GMT

I have tried the same set analysis unfortunately not working for me