topic Data from charts in variable in QlikView

Data from charts in variable

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone! Suppose I have this chart that shows some quantity per day.

I need to do this. Every time I choose a date, I need to compare the Q of the day selected with the Q that is recorded 7 days before.

Example

I choose 8/8/2018. Q = 7

I need to get the Q = 2 for the day 1/8/2018, so I can calculate 7-2

How can I do this? Thanks!

m_woolf — Fri, 24 Aug 2018 17:41:32 GMT

Something like (I didn't test):

=sum(Q) - sum({<Day={"$(=Day-7)"}>} Q)

MarioCenteno — Fri, 24 Aug 2018 17:42:29 GMT

Try

expression the last week - today

(sum({<Day={">=$(=Date(today()-7,'MM/DD/YYYY'))<=$(=Date(today(),'MM/DD/YYYY'))"}>}Q)

sum({<Day={">=$(=Date(today(),'MM/DD/YYYY'))<=$(=Date(today(),'MM/DD/YYYY'))"}>}Q)

)

Anonymous — Fri, 24 Aug 2018 18:13:19 GMT

I think this sentence "{<Day={"$(=Day-7)"}>} Q" is an "if-then" sentence that can be written like this, correct?

If(Day = "$(=Day-7)", Q)

I do not know what I'm doing wrong. The sentence works, but brings me the Q for 8/8/2018 instead of 1/8/2018...

Consider that when I select a date, the chart shows one row only. Maybe the problem resides in this fact?

m_woolf — Fri, 24 Aug 2018 19:09:22 GMT

Are you trying to show the difference in the chart, or in a text object?

Can you share a sample qvw?

Anonymous — Fri, 24 Aug 2018 19:39:03 GMT

Sure! Here you have a sample. Blue box activates when you select a date.