Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Dimension value + 1

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

1 Solution

Accepted Solutions

Re: Dimension value + 1

Hi,

Create straight table

take Week as dimension and

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

PFA

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
3 Replies

Re: Dimension value + 1

Hi,

Better if you create Week +1 dimension in script

or in your expression

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Not applicable

Re: Dimension value + 1

Hello.

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

I will send you excel file.

Re: Dimension value + 1

Hi,

Create straight table

take Week as dimension and

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

PFA

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Community Browser