Want to display only one data

[Paknanarn23]

I want to give information Ver1NGBoardCount Showing only 2 lines of information, what should I do?

[Zapparoli]

Hi Paknanarn23,

Maybe I did not understand correct your intentions, but do you want only to show the lines where it's no zero ?

If so, you can do it like this:

On your Table options, go to Data Handling, and uncheck include zero values.

Let me know your needs.

-Zapparoli

[Paknanarn23]

I made it in Qlikview. It cannot be done the way you have proposed. Is there any other way to suggest me?

[MayilVahanan]

HI

I think, in ur data model itself has duplicate records, If so, try to load distinct in script and verify it.

[Paknanarn23]

I've tried using distinct but still a lot of data. I got a hint that I need to concatenate the fields it duplicates.