Calculate cost for Two different ranges

[#1]

Hi all,

I'm new to qlikview and currently struck with a complicated scenario.

1) I'm building a straight table with different dimensions like Database_Name, Region, Employees, Criticality, then I'm writing two expressions to get Users and Servers to count numbers of servers and users on each Database.

Database	Region	Users	Servers	Criticality	Cost
megud	Asia	5	2	Non-Critical
wejguf	Europe	28	6	Critical
nhujger	Middle East	60	10	Non-Critical
segyui	Asia	90	15	Critical
loranu	Europe	120	30	Non-Critical

I was given this small table to caluclate the cost to maintain that database.

	Servers	Servers	Servers	Servers	Servers	Servers	Servers	Servers	Servers	Servers
Users	1	3	5	7	9	13	17	25	33	49
1	1 tiny	2*tiny	3*tiny	2 Small	3 Small	2 Medium	3 Medium	2 Large	3 Large	4 Large
9	2*tiny	2*tiny	3*tiny	2 Small	3 Small	2 Medium	3 Medium	2 Large	3 Large	4 Large
15	3*tiny	3*tiny	3*tiny	2 Small	3 Small	2 Medium	3 Medium	2 Large	3 Large	4 Large
21	2 Small	2 Small	2 Small	2 Small	3 Small	2 Medium	3 Medium	2 Large	3 Large	4 Large
25	3 Small	3 Small	3 Small	3 Small	3 Small	2 Medium	3 Medium	2 Large	3 Large	4 Large
39	2 Medium	2 Medium	2 Medium	2 Medium	2 Medium	2 Medium	3 Medium	2 Large	3 Large	4 Large
55	3 Medium	3 Medium	3 Medium	3 Medium	3 Medium	3 Medium	3 Medium	2 Large	3 Large	4 Large
73	2 Large	2 Large	2 Large	2 Large	2 Large	2 Large	2 Large	2 Large	3 Large	4 Large
105	3 Large	3 Large	3 Large	3 Large	3 Large	3 Large	3 Large	3 Large	3 Large	4 Large
150	4 Large	4 Large	4 Large	4 Large	4 Large	4 Large	4 Large	4 Large	4 Large	4 Large

Criticality	Area	Middle East	Europe	ASIA
	tiny	132.08	180.82	113.23
Non-Critical	small	204.38	217.60	246.93
	medium	348.98	391.16	314.33
	Large	438.18	538.28	449.13
	tiny	123.65	185.39	152.30
Critical	small	234.09	254.61	294.00
	medium	354.97	393.05	367.40
	Large	496.73	469.93	454.20

Example - If my number of Users are 5 and servers are 2 for a database then I need to look at ranges which gives me 2 times the tiny,

Then I need to look at region and Criticality. If it is non critical then I need to show non critical vale for Asia which is 2*246.93 for this example.

Appreciate your help,

Larry.

[#2]

please give me an advice on how to solve this issue. Any help is appreciated.

[ahaahaaha]

Hi,

It became interesting to work with your task.

The attached file describes the approach to the solution. All comments in the script code. Most of the code is converting the average cross-table into a simple one. Perhaps it makes sense to ask him right away in another form.

For analysis, all the code can be commented out, and then consistently remove comments as the tables load.

Hope this helps you a bit.

Regards,

Andrey