distinct Vs DISTINCT

[#1]

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]

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.

[#3]

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

[er_mohit]

Try This

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

[#5]

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

[#6]

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.

[#7]

@Mohit,

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