topic Dashboard Help in QlikView

Dashboard Help

Tue, 08 Apr 2014 16:48:18 GMT

Hi all,

I want to create simple dashboard in tabular format like below:

Any idea from anyone how can I create this format in QV?

Help appreciated.

	Total for Day	Cumulative for month	Daily variance to Plan		Cumulative variance to Plan
			Number	%	Number	%
Daily Sales
- Total	300	1000	-10	5%	-32	-3%
- Product 1	100	1100	-20	7%	-35	-4%
- Product 2	100	1200	-30	5%	-38	-5%
- Product 3	100	1300	-40	10%	-40	-4%

Total Amount
- Total	1500	1500	-10	5%	-32	-3%
- Product 1	500	2000	-20	7%	-35	-4%
- Product 2	500	2500	-30	5%	-38	-5%
- Product 3	500	3000	-40	10%	-40	-4%

Regards

Mak

Re: Dashboard Help

its_anandrjs — Tue, 08 Apr 2014 16:52:01 GMT

Yes you can create a straight table for this and with different formulas with different expression do you have sample data for this.

Re: Dashboard Help

Wed, 09 Apr 2014 08:22:59 GMT

Hi Anand,

Many thanks for your reply. I am sorry, I don’t have any sample data right now.

But I am very curious to know how can we set expressions displayed in two dimensions like vertical and horizontal as given example?

Regards

Mak

Re: Dashboard Help

vijetas42 — Fri, 11 Apr 2014 11:35:34 GMT

Hi Makarand,

You can use straight table or convert it to cross table as per your requirement and in that you can select expression total in expression tab and also check Totals in first row in presentation tab

I hope this will help you...

Thanks and Regards,

Vijeta Sharma