topic Re: chart display - show only certain rows (not all) in QlikView

chart display - show only certain rows (not all)

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

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

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.

qvw is attached.

Thanks for your advise.

Re: chart display - show only certain rows (not all)

sunny_talwar — Tue, 29 Mar 2016 13:40:01 GMT

Try this:

Re: chart display - show only certain rows (not all)

Wed, 30 Mar 2016 01:12:41 GMT

amazing!

Re: chart display - show only certain rows (not all)

Wed, 30 Mar 2016 09:17:48 GMT

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.

Re: chart display - show only certain rows (not all)

sunny_talwar — Wed, 30 Mar 2016 10:25:44 GMT

Add them as expressions instead of dimensions

Re: chart display - show only certain rows (not all)

Thu, 31 Mar 2016 01:22:58 GMT

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?

Re: chart display - show only certain rows (not all)

sunny_talwar — Thu, 31 Mar 2016 08:49:37 GMT

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