Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
shyamcharan
Creator III
Creator III

Date selections back ground

Hi Experts,

I have a dashboard, where one tab has work orders and the other tab has logs.

In Work Orders tab I have a date range selections for the work orders start date. In the Logs tab the i have the logs for which work orders are created. But in Logs tab too I have a date range that allows to select date range for the dates on which the logs are created.

Now, I want the dates in Log tab to be shown only the Log dates that are for specific Work Orders in Work Order Tab.

For example:

WO ID     WO Start Date     Log ID      Log Create Date

123          1 Jan 2014          L1               2 Jan 2014

135          3 Jan 2014          L2                5 Jan 2014

When a date range selection is made in WO tab like 1 jan to 3 jan, then in Log tab the only dates that should be able to be selected is 2 Jan and 5 Jan since only these dates are relavant to the logs created for the work orders in the Work order tab.

I hope I am clear. Please let me know if it is not clear.

So somehow, can we display a different background color for the calendar object in the Log tab so that only the date 2nd and 5th of Jan 2014 are with white background and the rest are with grey background?

Thanks in advance.

Regards,

Shyam.

10 Replies
amir_taub
Partner - Contributor II
Partner - Contributor II

may be you need to use "KEY TABLE"

but the best thing that you can do is to attach QVW and XLS .