topic Re: Qlikview Distinct in QlikView

Qlikview Distinct

kashjaniqlik — Fri, 05 Aug 2016 14:13:44 GMT

Hello

I have unique values in my excel spreadsheet (verified by removing the duplicate values and also checking for unique records) although loading these values in qlikview and using distinct, qlikview still seems to find duplicate values?

My data is a combination of numbers and alpha numeric values.

Thanks

Re: Qlikview Distinct

jpenuliar — Fri, 05 Aug 2016 15:27:10 GMT

can you post your data?

Re: Qlikview Distinct

Anonymous — Fri, 05 Aug 2016 15:28:43 GMT

HI,

If you have used DISTINCT keyword while loading , then it will find the distinct combinations ,

and it will take a bit more time than loading without distinct.

Re: Qlikview Distinct

krishnacbe — Fri, 05 Aug 2016 15:30:46 GMT

try this

=Only(Distinct Fieldname)

Re: Qlikview Distinct

kashjaniqlik — Fri, 05 Aug 2016 15:49:21 GMT

Hi Jonathan

Unfortunately I'm not able to post the data due to security issues.

Basically I have just one column in a spreadsheet which I'm loading in to a blank QVW. Doing a count of this column in qlikview - count ( fieldname), I get a few extra values then when I export this field in to a excel spreadsheet. It seems while exporting to a xls, qlikview is able to remove some dupes, although there aren't any dupes when just checking for uniqueness in the excel spreadsheet.

Re: Qlikview Distinct

kashjaniqlik — Fri, 05 Aug 2016 15:50:07 GMT

Hi Nitin

I'd like to use distinct in the set analysis. Please see my response above to Jonathan for further update.

Re: Qlikview Distinct

marcus_sommer — Fri, 05 Aug 2016 16:47:56 GMT

If you want to compare the data in qlik with the excel-data and the export-data you need to take tablebox for it which also contained a unique record-identifier which you could create within qlik per recno() and rowno() which also are a good indicator if a distinct or any where-clause effects the number of records.

- Marcus