Discussion Board for collaboration related to QlikView App Development.
I have a topic unfortunately with very much additional work in Excel for me. Maybe some of you can help me.
I have a table with values and then two additional red columns that calculate the difference between these two black columns
(one with positive amount, one with negative, but the value is the same, always).
Now I want to adapt that report.
Only the lines <> 0 in the red columns should appear. I know how to show only lines with value <> 0
But how can I only show lines with calculated result <> 0?
i think this is the only way unfortunately. but you do not want to hard code your condition though - i would create a hidden column with your condition expression which will evaluate to 1 or 0 and then use it for all your other expressions.
if (colHiddenExp > 1 , exp1)
if (colHiddenExp > 1 , expn)
it works partially. Now the lines which have values are shown with values. The other dont show a value.
But the tricky challenge for me is that the empty lines are not shown anymore.
(From that Screenshot only the two lines with -3560,92 and 399,05 should stay in that pivot)
but you have to add the if in each expression, also for the first two columns:
if(([IFRS AfA Per] - [HGB AfA Per] )<>0, [IFRS AfA Per])
if(([IFRS AfA Per] - [HGB AfA Per] )<>0, [HGB AfA Per])