topic Re: Show double Values in Listbox in QlikView

Show double Values in Listbox

Anonymous — Thu, 30 Jun 2016 10:08:05 GMT

Hi at all,

i'm new to work with Qlikview and have a simple Question:

i've a Listbox where some values are double:

I want to see every Value as single Value and not how often the Value is occourred.

Thanks for helping...

Re: Show double Values in Listbox

trdandamudi — Thu, 30 Jun 2016 11:55:37 GMT

I am not cleat on your requirement but If you remove the check mark for "Show Frequency" it will display only unique values. See attached screen shot:

Re: Show double Values in Listbox

Anonymous — Thu, 30 Jun 2016 12:08:34 GMT

Thanks for your answer.

Then i see every value once only and not how often it occourred.

For example:

The Value "24.4" appears twice. So i want to see the Value twice in this view:

Re: Show double Values in Listbox

qlikview979 — Thu, 30 Jun 2016 12:28:10 GMT

Hi,

Right Click on List box-->Properties-->GeneralTab-->Uncheck"Show Frequency Option".

Regards

Re: Show double Values in Listbox

krishnacbe — Thu, 30 Jun 2016 13:14:08 GMT

By Default distinct values are shown in a List box. the frequency can be removed as suggested by Thirumala or Mahesh.

But my question is do you want to remove the duplicates in List box or in data model.

Re: Show double Values in Listbox

ciaran_mcgowan — Thu, 30 Jun 2016 16:35:35 GMT

Hi Martin,

I know this won't meet your requirement but a list box will only show unique values, because it is generally used as a selector. If you have a list box containing numbers and two of them are the same, then you will have no idea which row you are selecting is associated with.

An easier way to put it is to think about it like this: if you have 1,000,000 rows of addresses, would you want the Country listbox to list out USA thousands of times or once? You click USA in the list box and other tables react to that selection, showing you the data you want to see.

If you must see each value individually in a box, you will have to use a straight table that contains other fields that make that row unique and then hide all columns (except ping_delay) in the presentation tab.