distinct values

[#1]

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?

[MK_QSL]

You can load like...

Load Distinct

     [Customer ID],

     [Customer Name],

     ....

From FileName;

[#3]

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

[hic]

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