topic Straight table question in QlikView

Straight table question

bhaskarsharma03 — Wed, 11 Jun 2014 08:11:14 GMT

Hi,

The attached file gives the temperature of different cities which are divided into different zones. I want to create a straight table that displays

City

Temperature of City

Avg Temp in the zone the city falls into

The delta between City temperature and avg temperature in the zone

The output should look like the below table. Please let me know if this can be handled in set analysis itself (how) or we need to take care of Avg zone temperature at the script level before fetching it to the front end.

City	City Avg Temp	Zone Avg Temp	Delta
Ahmedabad	46	38	8
Bangalore	33	39	-6
Chandigarh	40	44	-4
Chennai	44	39	5
Delhi	45	44	1
Gurgaon	46	44	2
Guwahati	34	32	2
Hyderabad	38	39	-1
Kolkata	36	32	4
Lucknow	44	44	0
Mumbai	36	38	-2
Noida	45	44	1
Pune	32	38	-6
Salem	42	39	3
Shillong	25	32	-7

Thanks in advance,

Bhaskar

Re: Straight table question

michael_maeuser — Wed, 11 Jun 2014 08:20:09 GMT

Hi,

see attached

Re: Straight table question

bhaskarsharma03 — Wed, 11 Jun 2014 08:28:19 GMT

Hi Michael,

Thanks for the response. I was however looking for a solution that doesn't require using aggregation function at the script level. Is it possible to achieve the same result without touching the script?

Regards,

Bhaskar

Re: Straight table question

Wed, 11 Jun 2014 08:28:52 GMT

Hi Bhaskar,

Please find a front end and a back end solution in the file attached.

Regards

Rahul