topic Can I create multiple dimension report like below format? in QlikView

Can I create multiple dimension report like below format?

Fri, 10 Jan 2014 14:32:12 GMT

The red line are average line for each pane window.

great thx in advance.

Re: Can I create multiple dimension report like below format?

Gysbert_Wassenaar — Fri, 10 Jan 2014 14:50:58 GMT

Yes, I think so. But it's going to be tricky. You would need to put to pivot tables on top of each other. One pivot table would use linear gauges for representation of the expressions with the indicator set to fill to value. The other would use linear gauges with the indicator set to Show Needle and use Line as style.

Re: Can I create multiple dimension report like below format?

Michiel_QV_Fan — Fri, 10 Jan 2014 14:58:56 GMT

Use a trellis with a dimension for Discount, Profit and Sales?

Re: Can I create multiple dimension report like below format?

Fri, 10 Jan 2014 14:59:08 GMT

I am new to QV, any way to show me how to do it step by step? or refer to previous posting

Re: Can I create multiple dimension report like below format?

Fri, 10 Jan 2014 15:07:42 GMT

I cannot add reference line to bar chart with more than one dimension. It just does not show up.

Re: Can I create multiple dimension report like below format?

marchoctober — Fri, 10 Jan 2014 22:48:44 GMT

Hi!

Please see attached possible way to think in solving this issue.

Your task to this issue is operating non QlikView data logic visualisation. It is looks like spreadsheet or similar, nevermind.

In order that you are going to get fine experience from this task, try to imagine QlikView logic for end user, what would he do and how, and get back from this to the current task, try to understand the data and the best way to visualize it. In attached example it is only sketch on how QlikView could solve tasks alike.

Thanks.

Re: Can I create multiple dimension report like below format?

marchoctober — Sun, 23 Feb 2014 10:46:49 GMT

Hi!

Did you try the solution in file? What could you say?