Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

chart display - show only certain rows (not all)

Hi,

have a table with 4 columns (A, B, C, D) as below

test-ecn1.JPG

How to show the table as a chart that if the values in C are the same, take the row of maximum D? For this, rows 2, 3 and the 2'nd last are NOT displayed as below.

test-ecn2.JPG

qvw is attached.

Thanks for your advise.

1 Solution

Accepted Solutions
sunny_talwar

6 Replies
sunny_talwar

Try this:

Capture.PNG

Not applicable
Author

amazing!

Not applicable
Author

Hi Sunny,

There are additional columns of the table. These make the chart display a bit more difficult.

For example there are added columns Item and Qty. Your suggestion works fine to display one more column Item, but if both Item and Qty are to be displayed, it doesn't work. Any way to refine it? qvw file is attached.

test-ecn3.JPG

sunny_talwar

Add them as expressions instead of dimensions

Capture.PNG

Not applicable
Author

good learning experience!

can i say that for a chart, dimensions define the scope (or combination) of data to be handled, and expressions apply to the particular scope of data?

sunny_talwar

Not sure I understand your question. Would you be able to elaborate?