How to select distinct values from a table

[Bobbet]

Hi,

  I wanted to filter the results of my Qlik table dashboard to distinct mobile numbers only. I tried to use the DISTINCT function but it did not work.

  Looking for recommendations.

  Thanks

Bobbet

[Lisa_P]

can you give more information ?

[Bobbet]

Hi Lisa_P,

     Here is the sample screen shot of the table. How can I display only distinct values of the mobile numbers?

     Thanks

     Bobbet

    

[Lisa_P]

I can only see distinct values

[JoshuaSolomon]

Hi,

 Use Only(distinct [Mobile number])

Regards,

Joshua.

[Bobbet]

Hi Lisa_P,

      Seems that the data is now okay. Will validate further. 

      Thanks for the reply.

Bobbet

[qlikcook]

@JoshuaSolomon : Have you actually tried it yourself? Didn't seem to work in my load editor...https://help.qlik.com/en-US/sense/September2020/Subsystems/Hub/Content/Sense_Hub/Scripting/Aggregati...

[QFabian]

Hi, maybe the object that you use was a table, not a filter pane.