topic Distinct in QlikView

Distinct

Thu, 19 Aug 2010 14:01:40 GMT

Hi,

Is it possible to use the Distinct function in the Expression of the calender object.

Regards,XXX

Distinct

Thu, 19 Aug 2010 14:05:33 GMT

Distinct

Thu, 19 Aug 2010 14:13:44 GMT

Hi,

If the function in your expression have the option [DISTINCT], you can use but what problemn do you have?

Distinct

Thu, 19 Aug 2010 14:13:46 GMT

Hi,

i have created the calender control from the feild with the Expression =Makedate(Year(AT),Month(AT),Day(AT)).

In the calender control the date is not displayed If i select the date from the drop down of the the calender control or the select the date from calender table.

any one can help me to find the solution??????????????

Regards,XXX

Distinct

Thu, 19 Aug 2010 14:15:31 GMT

Do you can post a file whith this example?

Distinct

suniljain — Thu, 19 Aug 2010 14:19:46 GMT

yes, You can use distinct function in Expression . But Can I know your exact requirement ?.

Regards

Sunil

Distinct

Thu, 19 Aug 2010 14:23:08 GMT

I think you need use a field AT with a full date, and not make a date with 3 fields?

Do you have a field date or you remove in your script....

I use year,month and day separated just the user can select with granularity.....but on the calendar object i use a full date!!!

Did you try that?

Distinct

Thu, 19 Aug 2010 18:02:16 GMT

Thanks for your response

@ Sunil i am not able use the Distinct option in Expression. Please see the Attachment.

@ Alexio i tried the full date as well. Since the field i am using is with datetime format hence there are duplicates of the same date. Hence i used the makedate function.