topic Referenced Value in QlikView

Referenced Value

Mon, 26 Jan 2026 18:19:17 GMT

Hello,

I have a graphic.

I set a referenced value e.g. year 2014

then i select year 2013

I sent values to Excel, but see only year 2013.

Is it possible to show also referenced value year 2014?

Thx.

Re: Referenced Value

ecolomer — Tue, 16 Dec 2014 22:47:40 GMT

Can you explain more, please

Re: Referenced Value

Tue, 16 Dec 2014 22:58:03 GMT

I have a graphic

Vertical numbers

Horizontal weeks

in the graphic you see pro week the value of sales that week for example year 2014.

I set these values as referenced.

Now i want to compare each week with year 2013.

i push button values to excel, i see only year 2013 weekly values

not for referenced week

Hope you understand what i mean?

thx. in advance.

Re: Referenced Value

kamal_sanguri — Tue, 16 Dec 2014 23:39:06 GMT

Hi Ama,

Could you please attach your QVW for reference....

Thanks,

Kamal

Re: Referenced Value

kamal_sanguri — Wed, 17 Dec 2014 00:07:44 GMT

Hi Ama,

I think this file can be helpful...

Thanks,

Kamal

Re: Referenced Value

shawn-qv — Wed, 17 Dec 2014 00:51:12 GMT

You won't get the underlying data (in Excel) for those you've set Reference to.

You might want to create 2 expressions, one to calculate sales (by week) for the current year, such that it's based on the current user selection or year(max(Date)).

The second expression could be current (year) selection minus 1. i.e. year(max(Date))-1