Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
nizamsha
Specialist II
Specialist II

Accumulation

Hi All

date and properties as dimension 

DatePropertiesValue
11/12/12A/c30
11/12/12Fridge20
12/12/12A/c40
12/12/12Fridge30
12/12/12TV60
13/12/12Fridge70
13/12/12LCD40



I have the following straight table what i want is  this

DatePropertiesValueresult
11/12/12A/c3030
11/12/12Fridge2020
12/12/12A/c4070
12/12/12Fridge3050
12/12/12TV6060
13/12/12Fridge70120
13/12/12LCD4040

in properties i have ac,fridge,tv and lcd .. in result i have some values ..how we r calculating the result is in properties field i have ac  for that i have result is 30. like wise i have fridge for that result is 20 but now is the point again in properties i have ac so .so already i hve value for ac is 30 but now i have 40 so it should sum 30+40 and display the result 70 like wise fridge too

0 Replies