topic Re: table zone request in QlikView

table zone request

Mon, 21 Dec 2015 18:03:56 GMT

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

Re: table zone request

sunny_talwar — Mon, 21 Dec 2015 18:12:28 GMT

Their birthday between two days?? you mean ID for people who have Birthday is between two days from today?

Re: table zone request

maxgro — Mon, 21 Dec 2015 18:16:26 GMT

2 days or 2 dates?

Re: table zone request

Mon, 21 Dec 2015 18:19:39 GMT

no for two dates i mean ,i want to inject a request in the table zone

thanks

Re: table zone request

Mon, 21 Dec 2015 18:20:55 GMT

no i mean the id pepole that their birhtday between to dates

Re: table zone request

Mon, 21 Dec 2015 19:19:01 GMT

any one can help me please

Re: table zone request

maxgro — Mon, 21 Dec 2015 19:57:24 GMT

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

];

Re: table zone request

Tue, 22 Dec 2015 07:38:15 GMT

Hi Maxgro ;

i can't open this file , could you please paste a request Hear

Thanks

Re: table zone request

maxgro — Tue, 22 Dec 2015 08:18:29 GMT

Script is in my previous post

The chart is a straight table chart with

2 dimensions

FIRSNAME

1 expression

only({$ <BIRTHDAY={">=19/12/2015<=23/12/2015"}>} BIRTHDAY)

Re: table zone request

Tue, 22 Dec 2015 17:14:47 GMT

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

Re: table zone request

maxgro — Tue, 22 Dec 2015 18:32:10 GMT

there is a .qvw here with 2 calendars objects

QlikView App: Dates, Date Ranges and Set Analysis