Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello all members i wish that you are fine,
i import a data from my qvd file like:
ID FIRSNAME BIRTHDAY
1 F1 D1
2 F2 D2
3 F3 D3
. .
. .
I insert a table zone in my sheet qlikview but i want to load only ID that thier birthday between two days
thanks all
.
.
Their birthday between two days?? you mean ID for people who have Birthday is between two days from today?
2 days or 2 dates?
hi
no for two dates i mean ,i want to inject a request in the table zone
thanks
no i mean the id pepole that their birhtday between to dates
any one can help me please
I'm not sure tounderstand the question
SET DateFormat='DD/MM/YYYY';
load * inline [
ID, FIRSNAME, BIRTHDAY
1 , F1 , 01/01/2015
2 , F2 , 20/12/2015
3 , F3 , 21/12/2015
4 , F3 , 23/12/2015
5 , F3 , 19/12/2015
6 , F3 , 21/12/2014
];
Hi Maxgro ;
i can't open this file , could you please paste a request Hear
Thanks
Script is in my previous post
The chart is a straight table chart with
2 dimensions
ID
FIRSNAME
1 expression
only({$ <BIRTHDAY={">=19/12/2015<=23/12/2015"}>} BIRTHDAY)
thanks maxgro that work perfefectly with chart table,
other question if you don't mind ,i want to use two calendars in my sheet to put this two dates , its possible !!!
thanks an other one