topic How to build a dashboard based on interactions data in QlikView https://community.qlik.com/t5/QlikView/How-to-build-a-dashboard-based-on-interactions-data/m-p/553300#M480568 <HTML><HEAD></HEAD><BODY><P>I have a tabular interactions data with column headers and data below them, along with it I have another workseet which has hours in a day (starting from 0 - 23), cannot use the cross tab since can expect the data structure to change. I want to populate the count of data under each hour.So please suggest how can i do this. Below is the expected output that I am looking for.</P><P><IMG alt="FinalExpectedOutput.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/49289_FinalExpectedOutput.jpg" /></P><P><BR /> </P></BODY></HTML> Wed, 20 Nov 2013 16:02:23 GMT 2013-11-20T16:02:23Z How to build a dashboard based on interactions data https://community.qlik.com/t5/QlikView/How-to-build-a-dashboard-based-on-interactions-data/m-p/553300#M480568 <HTML><HEAD></HEAD><BODY><P>I have a tabular interactions data with column headers and data below them, along with it I have another workseet which has hours in a day (starting from 0 - 23), cannot use the cross tab since can expect the data structure to change. I want to populate the count of data under each hour.So please suggest how can i do this. Below is the expected output that I am looking for.</P><P><IMG alt="FinalExpectedOutput.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/49289_FinalExpectedOutput.jpg" /></P><P><BR /> </P></BODY></HTML> Wed, 20 Nov 2013 16:02:23 GMT https://community.qlik.com/t5/QlikView/How-to-build-a-dashboard-based-on-interactions-data/m-p/553300#M480568 2013-11-20T16:02:23Z