topic Re: distinct values in QlikView

distinct values

Mon, 03 Feb 2014 14:25:24 GMT

I have loaded data into qlikview from an csv file, from mysql.I have one column that is now showing double values.

I have it in a table box.

I would like it to show only distinct values, is there a way in Qlikview to write this into the script?

Re: distinct values

MK_QSL — Mon, 03 Feb 2014 14:30:32 GMT

You can load like...

Load Distinct

[Customer ID],

[Customer Name],

....

From FileName;

Re: distinct values

Mon, 03 Feb 2014 14:34:22 GMT

Hi Zainab

strange behavior according QlikView's rules.

By default QV stores values only once.

If you have for example your name "Zainab" coming from more than 1 record it will be stored only once (ex : Zainab = 17) . Others "Zainab" ecords will be related to 17.

So it maight be a difference (like blanks in front of the string or after) which gives a different results

"Zainab"

"Zainab " look the same but are different

best regards

Chris

Re: distinct values

hic — Mon, 03 Feb 2014 22:00:47 GMT

Another possibility is that you have dates or numbers that are truncated. For example if you have

'2014-02-03 00:00:00'

'2014-02-03 01:00:00'

and format these values as dates, you will have to values that both look like '2014-02-03'. If you want these the be shown only once, you need to truncate or round, e.g. by using Floor() or DayStart().

HIC