Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Paknanarn23
Creator II
Creator II

Want to display only one data

Paknanarn23_1-1687592755263.png

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

 

4 Replies
Zapparoli
Creator II
Creator II

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.

Matheus_Zapparoli_0-1687609316619.png

Let me know your needs.

-Zapparoli

 

Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics

Paknanarn23
Creator II
Creator II
Author

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

Paknanarn23_0-1687744296836.png

 

MayilVahanan

HI

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Paknanarn23
Creator II
Creator II
Author

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