topic Dashboard format help! in QlikView https://community.qlik.com/t5/QlikView/Dashboard-format-help/m-p/516040#M557232 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I've been given a requirement of creating a dashboard with the format similar to the attached spreadsheet.</P><P></P><P>I've created my data model and brought in all the expressions (about 25 of them) into a straight table. I have selected 'Horizontal' in the Presentation tab to bring the expressions down onto the rows.</P><P></P><P>Now I have the issue of needing to report these expressions (and their variance to plan) by the last 4 weeks, 4 wk average and YTD. I have flags for these different selections which I can refer to using set analysis BUT my issue is I need these 'date' criteria to be at the top of the report. I've played with the idea of having seperate tables - but this is a no go as exporting to excel / scrolling is an issue. </P><P></P><P>Has anyone developed anything similar? Or can you provide advice on how to create this view?</P><P></P><P>Thanks</P><P>Adam</P></BODY></HTML> Thu, 27 Jun 2013 11:32:20 GMT 2013-06-27T11:32:20Z Dashboard format help! https://community.qlik.com/t5/QlikView/Dashboard-format-help/m-p/516040#M557232 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I've been given a requirement of creating a dashboard with the format similar to the attached spreadsheet.</P><P></P><P>I've created my data model and brought in all the expressions (about 25 of them) into a straight table. I have selected 'Horizontal' in the Presentation tab to bring the expressions down onto the rows.</P><P></P><P>Now I have the issue of needing to report these expressions (and their variance to plan) by the last 4 weeks, 4 wk average and YTD. I have flags for these different selections which I can refer to using set analysis BUT my issue is I need these 'date' criteria to be at the top of the report. I've played with the idea of having seperate tables - but this is a no go as exporting to excel / scrolling is an issue. </P><P></P><P>Has anyone developed anything similar? Or can you provide advice on how to create this view?</P><P></P><P>Thanks</P><P>Adam</P></BODY></HTML> Thu, 27 Jun 2013 11:32:20 GMT https://community.qlik.com/t5/QlikView/Dashboard-format-help/m-p/516040#M557232 2013-06-27T11:32:20Z Re: Dashboard format help! https://community.qlik.com/t5/QlikView/Dashboard-format-help/m-p/516041#M557233 <HTML><HEAD></HEAD><BODY><P>I have tried loading my expressions into a new table with the expression name as a value in a field (with the intention of bringing back this field as a dimension in a table) but this won't work as some of my expressions are ratios.</P><P></P><P>Adam</P></BODY></HTML> Thu, 27 Jun 2013 13:21:11 GMT https://community.qlik.com/t5/QlikView/Dashboard-format-help/m-p/516041#M557233 2013-06-27T13:21:11Z