Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Can I create multiple dimension report like below format?

The red line are average line for each pane window.

sample.jpg

great thx in advance.

6 Replies

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

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.


talk is cheap, supply exceeds demand
michielvandegoo
Valued Contributor

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

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

Not applicable

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

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

Not applicable

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

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

marchoctober
Contributor

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

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.

marchoctober
Contributor

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

Hi!

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

Community Browser