topic Re: Dimension value + 1 in QlikView

Dimension value + 1

Mon, 21 Sep 2015 07:08:43 GMT

Hello all,

I have a small problem with value presentation in table.

As you can see on screenshot, when I just add 1 to the week dimension, it just shows data shown in the blue square.

Do you have an idea how to get the values in green one?

Best regards

PrashantSangle — Mon, 21 Sep 2015 07:12:35 GMT

Hi,

Better if you create Week +1 dimension in script

or in your expression

modify it like sum({week={"=$(week+1)"}}sales)

Regards

Mon, 21 Sep 2015 07:52:02 GMT

Hello.

would you be so kind to show me how to do this?

I will send you excel file.

PrashantSangle — Mon, 21 Sep 2015 09:13:32 GMT

Hi,

Create straight table

take Week as dimension and

Sum({<Week={"$(=Week+1)"}>}[hours]) as Expression

PFA

Regards