Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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

maxgro
MVP
MVP

2 days or 2 dates?

Not applicable
Author

hi

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

thanks

Not applicable
Author

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

Not applicable
Author

any one can help me please

maxgro
MVP
MVP

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
Author

Hi Maxgro ;

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

Thanks

maxgro
MVP
MVP

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
Author

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