Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

calculated dimension

friends,

I have calculated a horizontal dimension and I need to insert some values ​​in the table.

See the attached example.

Thank!

1 Solution

Accepted Solutions
jerem1234
Valued Contributor II

Re: Re: Re: calculated dimension

Here, I had to add one small table to your script. But instead of using calculated dimensions, I flipped it and turned the expressions into a dimensions. This allowed me to create those arrows in your chart as you desired. Please find attached.

Hope this helps!

4 Replies
jerem1234
Valued Contributor II

Re: calculated dimension

Please find attached. I've included an extra table that uses the years as a dimension instead of using all hard-coded dimensions. That might be better than using multiple if statements, which may become cumbersome over time.

Also, instead of using a calculated dimension for the values, I used an expression instead under its corresponding column.

Hope this helps!

Not applicable

Re: Re: calculated dimension

Examente not what I need.

I need a column called Var appears on the same line as the Volume (Tons)

See the attached image.

Example.png

jerem1234
Valued Contributor II

Re: Re: Re: calculated dimension

Here, I had to add one small table to your script. But instead of using calculated dimensions, I flipped it and turned the expressions into a dimensions. This allowed me to create those arrows in your chart as you desired. Please find attached.

Hope this helps!

Not applicable

Re: Re: Re: calculated dimension

Excellent!

That's exactly what I wanted ...

Thank!

Community Browser