topic Filter in straight table for dimension column in QlikView

Filter in straight table for dimension column

kurakuaa — Sat, 16 Nov 2024 01:58:19 GMT

Hi All,

Below is the date column displaying data in straight table as a dimension.

Date

11-12-2019 00:30:00

11-12-2019 01:30:00

11-12-2019 02:30:00

12-12-2019 00:30:00

12-12-2019 01:30:00

So now in chart grid it should show for date column with date timestamp, but in drop down for same date column it should without timestamp and only date should be shown. I need below result in drop down.

11-12-2019

12-12-2019

Only these dates should be shown.

Please can anyone help me on this.

Thanks in advance.

Thanks,

Avinash

Re: Filter in straight table for dimension column

Arthur_Fong — Wed, 13 Nov 2019 07:49:48 GMT

Try this:

In Date ListBox Properties > General > Field > Dropdown select <Expression> :

=Date#(SubField(Date,' ',1),'DD-MM-YYYY')

Thanks and regards,

Arthur Fong

Re: Filter in straight table for dimension column

ramasaisaksoft — Wed, 13 Nov 2019 08:46:35 GMT

Just try to use

Date(Date Filed/your Dimension Name) as New field Name.it will gives the date of that field

Re: Filter in straight table for dimension column

kurakuaa — Wed, 13 Nov 2019 12:25:15 GMT

Thank you it is working.

Thanks,

Avinash