Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
upaliwije
Contributor II

EXPRESSION

I have  Pivot table in my qvw file where I don't get the expected output. My current output and expected output   is shown below

Screenshot_1.png

The rows where changes are needed shown in red color. In fact What I need is when there are values in  both column it should be nett off and balance shown in one column. Kindly help me correct my expression to obtain desired results.

 

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: EXPRESSION

Please find attached a solution. I have used straight table instead of pivot because of two reasons: 1. You are not reporting a hierarchical data but a flat one and that can be simply reported using straight table. 2. You can use simpler expressions without aggr() to improve app performance.

 

View solution in original post

2 Replies
Highlighted
MVP
MVP

Re: EXPRESSION

Please find attached a solution. I have used straight table instead of pivot because of two reasons: 1. You are not reporting a hierarchical data but a flat one and that can be simply reported using straight table. 2. You can use simpler expressions without aggr() to improve app performance.

 

View solution in original post

Highlighted
upaliwije
Contributor II

Re: EXPRESSION

Thanks Tesesco,

It works but Total Value  row is not shown in the Straight Table