Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Modifying Static Excel Table

I am facing an issue updating my excel table. Currently, I designed my dashboard such that it will take in this Question Master Table. The changes made for this table is minimal but there is a chance that they might want to change the Question Label. I use isValue as an indicator that the Question is VALID/INVALID.

The Question 2 is changed.

Question Isvalue 0.JPG

The new Question has been set and the isValue is 1.

Question Isvalue 1.JPG

The real problem i am facing is when i reload on my dashboard. For the Academic Year 2015, it is showing the correct Question Label.

But it does not show the previous Question Label for the previous Academic Year from 2010 to 2014. Initially i thought using Academic Year as an identifier would be good but the changes made on the Question Master table will only take place once in a few years. Hence, inefficient. I can afford to make more columns on the excel sheet because it will not affect the dashboard. Any ideas how i can overcome this?

Dash.JPG

0 Replies