topic Re: Problem in Expression (one field two values ) in QlikView

Problem in Expression (one field two values )

Fri, 30 May 2014 09:18:31 GMT

I have created a timeline for lectures

Now one lecture is starting from 9 am to 12 pm and the same lecture starts after 1 hour break from 1 pm to 4 pm

I want to show a bar from 9 am to 12 pm and after a gap from 12 pm to 1 pm , a bar should again appear from 1 to 4 pm

Please find the attached file with it.. Please Help !!!

i am sharing the example

crusader_ — Fri, 30 May 2014 09:29:18 GMT

Hi,

You should artificially create unique ID for every lecture.

It's easy to do in LOAD statement

LOAD *,

autonumber([Module Name]&[Date]&[Start Time]) as ID

Resident YourDatasource;

and use it as Dimension.

HTH

Andrei