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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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