topic Re: Conditional Show in QlikView

Conditional Show

Mon, 22 Jul 2013 20:10:53 GMT

I have a straight table that contains data about patients with upcoming visits. In the table I only want to show those patients who have an appointment schedule sometime over the next two weeks.

I am trying to use the Conditional Show with the formula

Date(NOV_DATE)<=(Date(TODAY()+14))

but it doesn't seem to be doing anything. Any suggestions?

Re: Conditional Show

Anonymous — Mon, 22 Jul 2013 20:22:29 GMT

Hello,

You add the condicional 'Date(NOV_DATE)<=(Date(TODAY()+14))' in all expressions of the straight table:

if(Date(NOV_DATE)<=(Date(TODAY()+14)), ...expression...)

Re: Conditional Show

Tue, 23 Jul 2013 06:05:15 GMT

Are u doing in Layout tab of Propertry of Chart?

If yes then u need to know abt that functionality.

it used to Show the Whole object, if condition is true then Show the object else hide the object.

For ur requirement use below expression in ur expression tab.

Sum(if(Date(NOV_DATE)<=(Date(TODAY()+14)), Sales))

Regrads,

Kabilan K

Re: Conditional Show

Tue, 23 Jul 2013 06:14:08 GMT

try this

and write date field in the format.

if(date(appont_schedule_date)>=date(today())+14,Patient)

Re: Conditional Show

er_mohit — Tue, 23 Jul 2013 06:20:42 GMT

try this

make sure date format is same as Date(today()) if not then in script write for NOV_DATE is

date(date#(NOV_DATE,'DD/MM/YYYY'),'DD-MM-YYYY') AS NOV_DATE

IT means the first format is your default format see your Date field Format and replace it with and second one is the format which you desire like Date(today()) format

aggr(only({<NOV_DATE={"<=$(=Date(TODAY()+14)))"}>}NOV_DATE),NOV_DATE)