topic How get 'difference' from today's - sales amount minus yesterday's sales amount in App Development

How get 'difference' from today's - sales amount minus yesterday's sales amount

loganathan — Fri, 15 Nov 2024 20:56:06 GMT

Hi All,

I not familiar in Qliksense and need help on below logic.
basically i have populate 'Difference' column in table (not in report). To find the 'Sales difference' by calculating Today's 'Sales Amount' minus Yesterday's
'Sales Amount' to generate the column 'Difference' as attached in data table. and it has to be by
SaleID, Desc, Reported Date and Sale Date. for more details please find the attached sample data excel. where it has excel formula to populate 'Difference' column.

Thanks & Regards
Loga

Re: How get 'difference' from today's - sales amount minus yesterday's sales amount

Lisa_P — Wed, 26 Jun 2024 23:36:05 GMT

Use Sum(Sale Amount) as a measure, name it Amount, then use this formula:

Amount - Above(Total Amount, 1, 1)

Re: How get 'difference' from today's - sales amount minus yesterday's sales amount

loganathan — Thu, 27 Jun 2024 05:07:34 GMT

Hi Lisa,

Thanks for your effort. but i want this to be created in table means in 'edit script' as a field. and its has to grouped by Reported date and SaleID.

Re: How get 'difference' from today's - sales amount minus yesterday's sales amount

Kingmaker — Thu, 27 Jun 2024 09:23:36 GMT

Use previous or peek function to pick previous value

Re: How get 'difference' from today's - sales amount minus yesterday's sales amount

amonjaras_c40 — Thu, 27 Jun 2024 19:08:57 GMT

Hello!

To do it in the script, let’s assume you have loaded your table as Table 1, then:

Table2:

Noconcatenate Load

SaleID,

Desc,

[Reported Date],

[Sale Date],

[Sale Amount],

if(SaleID=peek(SaleID) and [Reported Date]=peek([Reported Date]), [Sale Amount]-peek([Sale Amount]),[Sale Amount]) as Difference

Resident Table1

Order by SaleID,[Reported Date],[SaleDate];

Hope this helps!