topic Re: Want to display only one data in Featured Members

Want to display only one data

Paknanarn23 — Sat, 24 Jun 2023 07:46:50 GMT

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

Zapparoli — Sat, 24 Jun 2023 12:22:46 GMT

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 — Mon, 26 Jun 2023 01:51:46 GMT

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

MayilVahanan — Mon, 26 Jun 2023 03:50:42 GMT

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

Paknanarn23 — Mon, 26 Jun 2023 08:32:18 GMT

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