Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
suppose we have data from 2014 till now,but when i select 2017 only the current data should be visible not historical
how we can implement this in qlikview.
If your data model is created correctly, QlikView will automatically do this for you. You won't need to do anything special
how data model will help in this,kindly help in understanding.
QlikView is build on the premises that if your calendar is correctly linked to your main fact table, selections in any date or year field should restrict and show your only those dates or years which has been selected (unless and otherwise you have set analysis which tell them to now adhere to the selections).
Year, Value
2010, 10
2011, 20
2012, 15
If you select 2012, you will only see value = 15, others will just hide