topic Modifying Static Excel Table in QlikView https://community.qlik.com/t5/QlikView/Modifying-Static-Excel-Table/m-p/995892#M970933 <HTML><HEAD></HEAD><BODY><P>I am facing an issue updating my excel table. Currently, I designed my dashboard such that it will take in this <STRONG>Question Master Table</STRONG>. The changes made for this table is minimal but there is a chance that they might want to change the <STRONG>Question Label</STRONG>. I use <STRONG>isValue</STRONG> as an indicator that the Question is <STRONG>VALID/INVALID.</STRONG></P><P></P><H2>The Question 2 is changed.</H2><P><IMG alt="Question Isvalue 0.JPG" class="jive-image image-1" src="/legacyfs/online/99592_Question Isvalue 0.JPG" style="height: 171px; width: 620px;" /></P><H2>The new Question has been set and the isValue is 1.</H2><P><IMG alt="Question Isvalue 1.JPG" class="jive-image image-2" src="/legacyfs/online/99591_Question Isvalue 1.JPG" style="line-height: 1.5em; font-size: 13.3333px; height: 45px; width: 620px;" /></P><P>The real problem i am facing is when i reload on my dashboard. For the Academic Year 2015, it is showing the correct <STRONG>Q</STRONG><STRONG>uestion Label.</STRONG></P><P>But it does not show the previous <STRONG>Q</STRONG><STRONG>uestion Label</STRONG> 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 <STRONG>Question Master table</STRONG> 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?</P><P><IMG alt="Dash.JPG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/99596_Dash.JPG" style="max-width: 620px; height: auto;" /></P></BODY></HTML> Tue, 22 Sep 2015 02:15:55 GMT 2015-09-22T02:15:55Z Modifying Static Excel Table https://community.qlik.com/t5/QlikView/Modifying-Static-Excel-Table/m-p/995892#M970933 <HTML><HEAD></HEAD><BODY><P>I am facing an issue updating my excel table. Currently, I designed my dashboard such that it will take in this <STRONG>Question Master Table</STRONG>. The changes made for this table is minimal but there is a chance that they might want to change the <STRONG>Question Label</STRONG>. I use <STRONG>isValue</STRONG> as an indicator that the Question is <STRONG>VALID/INVALID.</STRONG></P><P></P><H2>The Question 2 is changed.</H2><P><IMG alt="Question Isvalue 0.JPG" class="jive-image image-1" src="/legacyfs/online/99592_Question Isvalue 0.JPG" style="height: 171px; width: 620px;" /></P><H2>The new Question has been set and the isValue is 1.</H2><P><IMG alt="Question Isvalue 1.JPG" class="jive-image image-2" src="/legacyfs/online/99591_Question Isvalue 1.JPG" style="line-height: 1.5em; font-size: 13.3333px; height: 45px; width: 620px;" /></P><P>The real problem i am facing is when i reload on my dashboard. For the Academic Year 2015, it is showing the correct <STRONG>Q</STRONG><STRONG>uestion Label.</STRONG></P><P>But it does not show the previous <STRONG>Q</STRONG><STRONG>uestion Label</STRONG> 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 <STRONG>Question Master table</STRONG> 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?</P><P><IMG alt="Dash.JPG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/99596_Dash.JPG" style="max-width: 620px; height: auto;" /></P></BODY></HTML> Tue, 22 Sep 2015 02:15:55 GMT https://community.qlik.com/t5/QlikView/Modifying-Static-Excel-Table/m-p/995892#M970933 2015-09-22T02:15:55Z