How to show Active data as well as Historical data in a table

[sanjaya9203]

Hi Friends,

I am working on development of an App where customer needs to populate the Active tariff details(.i.e By default Active/Valid tariffs should be available in the report) on the landing page.

By default, yes, report should show Active/valid tariff (meaning default validation), but it is possible that user can remove the default filter and wants to see a specific time-period tariff or historical tariff.

Adding sample data for your reference.

Your Help is highly appreciated.

Thank you,

Saan

[pensa-qlik]

Hey Saan,

Do you want to use the filter panes to allow the user to specify which date range they want or do you want visualizations to be hard coded to set date ranges? For the second option you could use Set Expressions in the visualization to lock the chart to only show a specific range and not be affected by other filters.

Let me know if that helps or if you want to provide more info on your use case.

[sanjaya9203]

Thanks Pensa for your faster response.

I am planning to use the filter panes to allow user to specify which date range they want, which will gives to user more flexibility. So on landing page user will see only valid tariff numbers by default. when user filters the date range to see for more history of the said tariff number, then the table should display the historical data.

Hope it clarifies you.

Thank you.

[Gabbar]

Use bookmark to set a default filter for a sheet, when user will land on the sheet filter will already be applied and then if user wants he can remove the filter.

[pensa-qlik]

If you want the user's to type specific date values into the filter then they could type '>1/1/2020 and <1/1/2021' and that will update the charts to show the values in that date range. If you don't want them to have to do that typing, you could use the 'date picker' visualization under 'custom objects' to let the user have any easier visualization to choose their date range. 

Anytime the user updates the filter or date picker, it will update the other charts to only show historical data. Unless you have a set expression on the other charts for them not to update.