Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Is it possable to not show value if the same as the line above in table

Hi
I have a report that I’m trying to create that will simply be exported to
excel, the data is correct and exports fine but I have been asked if it cannot
display the line if it is the same as the one above and just show the detail on
the line. (It’s kind of hard to explain, see the picture below)

The top image is what I have and the bottom image is what they want.

Thanks in advance experts!

qv.png

5 Replies
MVP
MVP

Re: Is it possable to not show value if the same as the line above in table

Well, the first thing that comes to mind is to convert the chart from a Straight Table to a Pivot Table and that would ensure the proper grouping of the identical values.

If, however, you want to say with the Straight Table, I'd suggest to play with the Text Color attribute of the dimension. Try using finctions like ABOVE() to compare the current value with the previous value. When the values are identical, set the Text Color to transparent - ARGB(0,0,0,0).

cheers,

Oleg Troyansky

MVP
MVP

Re: Is it possable to not show value if the same as the line above in table

Have you tried a pivot table?

Not applicable

Re: Is it possable to not show value if the same as the line above in table

If i change it to a pivot it displays correctly in qlikview but when you export to excel it creates the same as the straight table.

I have never used the Above function before so will do some more reading on that as my first try didn't work.

=if(RMA_No = Above(RMA_No),ARGB(0,0,0,0),rgb(0,0,0))

MVP
MVP

Re: Is it possable to not show value if the same as the line above in table

Works perfectly for me:

Capture.PNG.png

MVP
MVP

Re: Is it possable to not show value if the same as the line above in table

Try

=if(RMA_No = Above(TOTAL RMA_No),ARGB(0,0,0,0),rgb(0,0,0))

Community Browser