Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

table zone request

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

.

.

10 Replies
sunny_talwar
Not applicable

Re: table zone request

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

maxgro
Not applicable

Re: table zone request

2 days or 2 dates?

Not applicable

Re: table zone request

hi

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

thanks

Not applicable

Re: table zone request

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

Not applicable

Re: table zone request

any one can help me please

maxgro
Not applicable

Re: table zone request

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

];

1.png

Not applicable

Re: table zone request

Hi Maxgro ;

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

Thanks

maxgro
Not applicable

Re: table zone request

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)

Not applicable

Re: table zone request

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