Year Filter

[Anonymous]

Hi,

I am having an issue applying a year filter in NPrinting.

I have two dates columns but need the year filter to filter on both of these. Below are the two column I have in the data load editor but these are in the same SQL script. These dates refer to orders created and orders shipped.

Column 1: DATE(MonthStart([Created]), 'YYYY') as CreatedYear

Column 2: DATE(MonthStart([OutTimestamp]), 'YYYY') as OutTimestampYear

LOAD [LocationPartID],

           [TotalQty],

          Created,

          DATE([Created],'DDMMMYYY') as Created,

          DATE(MonthStart([Created]), 'YYYY') as Year,

          [OutTimestamp],

          DATE(MonthStart([OutTimestamp]), 'YYYY') as OutTimestampYear

FROM [Inventory.qvd]

(qvd);

I am not able to alias both of these columns as 'Year' as this will not be accepted, so if there are way around this?

Thank you in advance for any help.

[Lech_Miszkiewicz]

Well

This comes down to your data model in Qlik app.

It is not Nprinting related question.

You will have to provide us with information about your script and model. To be frank this topic is not a place for this conversation since it goes of the track.

Basicly you need to get your Qlik application right in first place.

All nprinting filters are just like listbox selections so before you come to Nprinting make sure you check how they will work directly in Qlik.

Cant help more here

Cheers

Lech