Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem in Expression (one field two values )

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

1 Reply
crusader_
Partner - Specialist
Partner - Specialist

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