topic Re: distinct Vs DISTINCT in QlikView

distinct Vs DISTINCT

Wed, 01 May 2013 16:21:37 GMT

Please find the below expression.

if(count(distinct [Carrier Name]) = 1, [Carrier Name], 'others')

Now, when I type "Di" of "DISTINCT" keyword in the expression window, Qlikview automatically gives me suggestion- DISTINCT, so I just select it.

However, the keyword DISTINCT does not give me expected output.

I had to manually make it lowercase to get the desired results. So, if upper case is not working, why does Qlikeview gives such a wrong suggestion?

jagan — Wed, 01 May 2013 16:37:14 GMT

Hi Prasad,

I think there is no difference between DISTINCT and distinct. Your expression

if(count(distinct [Carrier Name]) = 1, [Carrier Name], 'others')

If there are multiple (>1) Carrier Names by the dimension in your chart then Others is displayed, otherwise corresponding Carrier Name is displayed.

Hope this helps you.

Regards,

Jagan.

Fri, 03 May 2013 06:57:27 GMT

In that case, why does the output come only after writing distinct ? and not with DISTINCT?

er_mohit — Fri, 03 May 2013 07:29:08 GMT

Try This

count(distinct if([Carrier Name]) = 1, [Carrier Name], 'others'))

Fri, 03 May 2013 07:42:21 GMT

HI ,

Which version you are using ?.

Can you provide the sample data which you are using .

Also provide the Dimension and Expressions used in the chart .

//yusuf

Mon, 06 May 2013 15:37:46 GMT

Hi Yusuf,

I am using version 11.20.11718.0 SR1 (Desktop Free Version)

I tried to upload the file for sharing with you but it's size is 54 MB

The expression used is : if(count(distinct [Carrier Name]) = 1, [Carrier Name], 'others')

Dimension is only Carrier Name.

Mon, 06 May 2013 15:40:50 GMT

@Mohit,

My issues is different. I got the expression and correct output.