Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist II
Specialist II

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!

View solution in original post

4 Replies
jerem1234
Specialist II
Specialist II

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
Author

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
Specialist II
Specialist II

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
Author

Excellent!

That's exactly what I wanted ...

Thank!