topic help in expression in QlikView

help in expression

Anonymous — Sun, 20 May 2012 20:07:34 GMT

Table 1:

timind_ID Timing

1 9 - 9:30

2 9:30 - 10

3 10 - 10:30

Table2:

tiiming_ID BookingDate

2 21/5/2012

3 22/5/2012

1 23/5/2012

1 22/5/2012

3 21/5/2012

Result:

Timing 21/5/2012 22/5/2012 23/5/2012

9-930 Booked Booked

9-30 - 10 Booked

10- 10:30 Booked Booked

swuehl — Sun, 20 May 2012 20:30:15 GMT

You could try it like this:

Just load your tables as is (I think in above post, there are some typos which probably are not part of your script?).

Then create a pivot table with dimensions BookingDate and Timing and as expression

=if(timing_ID, 'Booked')

Then drag BookingDate dimension to the top of the pivot.

Hope this helps,

Stefan

Anonymous — Sun, 20 May 2012 20:44:43 GMT

i need to show today ,tomorrow,dayaftertomorrow booked date only...

Anonymous — Sun, 20 May 2012 20:54:30 GMT

I tried like this but its not working

timing as dimension

expression like =if(Booking_Date = Today(), 'Booked',' ')

but its not working

swuehl — Sun, 20 May 2012 21:39:35 GMT

With my suggested chart, either try a calculated dimension instead of dimension BookingDate (still first dimension Timing):

=if(BookingDate>=today() and BookingDate<=today()+2,BookingDate)

(and check Suppress when Value is Null in dimension tab)

or a set expression as expression

=only({<BookingDate={">=$(=today())<=$(=today()+2)"}>} if(timing_ID,'Booked'))