Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am summing the totals for each measured day which is right when looking at one days worth of data in a column, but when I highlight two dates I want them to subtract each other and show in a column.
For example, the first column ‘unassigned’ should read 4/29/14 – 4/28/14
= (10,001).
It is reading (4/29/14) 309,719 + (4/28/2014) 299,718 = 609,437 which is
incorrect.
Is this possible in Qlik? I attached a screen shot.
Thank you,
Jason
Could you upload a small sample application to demo your data model and current analysis?
This will help us to help you.
In general, using all records in your current selection within the aggregation is standard behaviour of QV analysis, so a
sum(VALUE) will sum up all values, limited by your date selections and grouped by the dimensions in the chart, but will not apply any different logic like calculating differences by default. So you would need to tell QV what do to, either in your chart expressions or maybe possibly in the script.
But as said, to help you more, I think you need to detail your requirements and settings, the screenshot is not giving enough information to help you.
Thank you Swuehl for the reply!
I was given these two formulas as well, but could not get them to work correctly.
Sum({$<Date={$(=Only(Date)-1)}>}LineSalesAmount) for the
previous day and
Sum({$<Date={$(=Only(Date)}>}LineSalesAmount) for the
current day.
Where can I upload a sample at? I am not seeing a link to add the qvw file.
In the "Reply" window, find "Use advanced editor" on the top right. When you click it, there will be Attach on the bottom right.
Thank you Michael!