Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Trellis Chart Grouped Expressions

Good Day All,

In the attached QVW example I have Purchase Receipt transactions whose cost I want to show by Item and MonthYear in a trellis chart. Additionally, I want to show the percentage change from the prior cost. The expressions are Grouped. To observe the results I made the chart a fast change between a pivot table and a bar chart.

The costs and percentage change renders correctly in the pivot table, but the percentage does not in the trellis chart.

Any thoughts on this behavior?

Thanks in advance,

Rich D

1 Solution

Accepted Solutions
Not applicable

Trellis Chart Grouped Expressions

because Before function can only be used with Pivot tables, it returns null for all other chart types...so, you are not getting values for Trellis Chart....I hope it is helpful and I believe you know other ways to achieve the same output....

3 Replies
Not applicable

Trellis Chart Grouped Expressions

Anyone encounter this?

Not applicable

Trellis Chart Grouped Expressions

because Before function can only be used with Pivot tables, it returns null for all other chart types...so, you are not getting values for Trellis Chart....I hope it is helpful and I believe you know other ways to achieve the same output....

Not applicable

Trellis Chart Grouped Expressions

Thank you Ashutosh,

I guess it's back to the drawing board for this one.

Rich

Community Browser