Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
bgreennc
Contributor II
Contributor II

Different sheets in the user interface has different dates

Hello Qlikview experts. I have an issue I am hoping you can help with.

I have an application that has 10 different sheets. The first five sheets uses a set of dates to display data. The second five sheets uses a different set of dates to display data. When a user selects dates from one of the first 5 sheets, then they move to the one of the sheets that is in the next group of 5, the date criteria they have selected should be removed, and they must select data from one of the sheets in that group of 5 before seeing data. When they go back to the first group of 5 sheets, the date criteria they have selected in the second group of 5 must be removed, and they need to select data criteria from one of these 5 sheets to see data.

 

The 5 tabs in this orange box displays data based off of ‘Create date’, ‘Accept date’, and ‘Confirm date’. The create, accept, and confirm dates for data set ‘1’ are different than the create, accept, and confirm dates for data set ‘A’

bgreennc_0-1617650422034.png

 

Data set ‘1’

bgreennc_1-1617650422072.png

 

 

 

The 5 tabs in this orange box displays data based off of ‘Create date’, ‘Accept date’, and ‘Confirm date’. The create, accept, and confirm dates for data set ‘A’ are different than the create, accept, and confirm dates for data set ‘1’

 

 

Data set ‘A’

 

 

 

This application needs to perform like it is two separate applications. When the user is navigating within data set ‘1’, the application should perform as a normal application does. When the user selects a tab in data set ‘A’, the date criteria from data set ‘1’ needs to be cleared, and the user needs to make a date selection from the data set ‘A’ tab in order to see data.

When the user clicks back on one of the tabs from data set ‘1’, the date criteria selected in data set ‘A’ needs to be cleared, and the user needs to make a date selection from the data set ‘1’ tab in order to see data.

 

Requirements:

  • The date criteria that is selected in data set ‘1’ can be applied to the other sheets in data set ‘1’
    1. The user can navigate within the data set ‘1’ sheets as usual.
  • When the user selects one of the sheets in data set ‘A’, the date criteria selected from data set ‘1’ needs to be cleared, and the user needs to make a date selection from the data set ‘A’ tab in order to see data.
  • The date criteria that is selected in data set ‘A’ can be applied to the other sheets in data set ‘1’
    1. The user can navigate within the data set ‘1’ sheets as usual.
  • When the user selects one of the sheets in data set ‘1’, the date criteria selected from data set ‘A’ needs to be cleared, and the user needs to make a date selection from the data set ‘A’ tab in order to see data.

 

Thanks in advance for your support.

Labels (1)
11 Replies
bgreennc
Contributor II
Contributor II
Author

Yes. The Analysis(1) tab has the same filters, plus 4 additional ones.

bgreennc
Contributor II
Contributor II
Author

Hello jwjackso,

The end user liked the alternate state solution. I am considering this topic closed.

Thanks for your help and your quick responses.

Best Regards,

Bgreennc