topic Re: How to make a box with indicators? in QlikView

How to make a box with indicators?

Anonymous — Mon, 09 Nov 2015 16:02:46 GMT

Cycle button: Company Area Article	sum(Forecast)	sum(Sales)	Realized sum(Forecast) - sum(Sales)
Netherlands	150	100	- 50
England	100	200	+ 100
Italy	50	50	0

Cycle button:

Company

Area

Article

sum(Forecast)

sum(Sales)

Realized sum(Forecast) - sum(Sales)

Netherlands

150

100

- 50

England

100

200

+ 100

Italy

Forecast - Sales indicators

When you click on the pivot table selects all records of dimensions 'Company', 'Area' or 'Article' where the forecast is behind Sales.

Idem for icons and to see which records are on schedule.

How do I realize this box with indicators?

Re: How to make a box with indicators?

miguelbraga — Mon, 09 Nov 2015 17:05:10 GMT

Hey there,

Can you please share a (QVW) document and/or a Excel file with your results?

Thanks,

Re: How to make a box with indicators?

Mon, 09 Nov 2015 17:15:15 GMT

one option would be to build text boxes and when defining each text box, point to the imate you want - you can then go to the Action tab and make the appropriate selections as far as what you want to do when the user clidcks such as select in field and the field would be company

Re: How to make a box with indicators?

Anonymous — Thu, 12 Nov 2015 09:35:16 GMT

Here the Excel file with results.