Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

kashjaniqlik
Not applicable

Qlikview Distinct

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

6 Replies
jpenuliar
Not applicable

Re: Qlikview Distinct

can you post your data?

gupta_n8
Not applicable

Re: Qlikview Distinct

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.

krishnacbe
Not applicable

Re: Qlikview Distinct

try this

=Only(Distinct Fieldname)

kashjaniqlik
Not applicable

Re: Qlikview Distinct

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.

kashjaniqlik
Not applicable

Re: Qlikview Distinct

Hi Nitin

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

marcus_sommer
Not applicable

Re: Qlikview Distinct

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