Re: reducing of data from one field - Qlik Community

Anonymous · ‎2017-04-18

I have a datefield which is having lot of data

now i just want to restrict it to one year data how to do that

Anil_Babu_Samineni · ‎2017-04-18

May be this

If(Year <> '2014', Year)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2017-04-19

It's hardcoding value,I just want to restrict to last year or latest year data

Anonymous · ‎2017-04-19

Data is coming from a qvd where to write the condition

Peter_Cammaert · ‎2017-04-19

In the LOAD FROM statement of that particular QVD.

Anonymous · ‎2017-04-19

and how to resticr to one year data .

Anonymous · ‎2017-04-19

yes i separated the values with commas ,still its giving me error.

can we use 3 conditions in where

is there any other way of putting the conditions ,

MindaugasBacius · ‎2017-04-19

Maybe this would work for you:

Where AddYear(Today(), -1) <= Date

Anonymous · ‎2017-04-19

have a look here:

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptRegularStatement...

vinieme12 · ‎2017-04-19

Please post your current load script

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.