Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can you give more information ?
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
I can only see distinct values
Hi,
Use Only(distinct [Mobile number])
Regards,
Joshua.
Hi Lisa_P,
Seems that the data is now okay. Will validate further.
Thanks for the reply.
Bobbet
@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...
Hi, maybe the object that you use was a table, not a filter pane.