I need to replicate a QlikView dashboard which is a reduced version of the main one and performs a binary load from the main ETL which has data from 2017 to today. But the user can only see and select the data from the last 2 months.
I can't understand how it has been done.
If i put the Date.KEY field in a listbox, i see all the values from 2017 to today but only the last 2 month are selectable while the other ones are light grey and nothing happens if i try to select one. From the data model viewer i can see all the data.
No relevant actions or triggers on the Date.KEY field. Tried to unlock fields and clear, nothing happened. No Section Access on field/values. Nothing strange in the QMC task.
Can you help me find out how the app has been limited to the last 2 months?
