Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
lavrendis
New Contributor

How to avoid duplicates

Hi There,

i have the following formula on a table that has several same entries of "commande client". I want to avoid having duplicates so, if there are several lines with the same commande client it should count as 1.

Thank you for your help,

count({$<[TIMECURRENTSTATUT]={">5"},[Code]={"3","5","20","25","4"}, [Sélection KPI]={"1"},[Regroupement]={"PRO","FIL"}>}[Commande client])

Tags (1)
1 Solution

Accepted Solutions
viveksingh
Contributor II

Re: How to avoid duplicates

Hi Lawrence,

Can you try with Distinct

count(distinct {$<[TIMECURRENTSTATUT]={">5"},[Code]={"3","5","20","25","4"}, [Sélection KPI]={"1"},[Regroupement]={"PRO","FIL"}>}[Commande client])

2 Replies
viveksingh
Contributor II

Re: How to avoid duplicates

Hi Lawrence,

Can you try with Distinct

count(distinct {$<[TIMECURRENTSTATUT]={">5"},[Code]={"3","5","20","25","4"}, [Sélection KPI]={"1"},[Regroupement]={"PRO","FIL"}>}[Commande client])

lavrendis
New Contributor

Re: How to avoid duplicates

Thank you Vivek,

this works fine.

BR,

Lawrence