Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
nizamsha
Specialist II
Specialist II

accumulation based on two dimension

Hi All

this is my inline table

Date, Properties, Value
11/12/12, Fridge, 20
11/12/12, A/c, 30
12/12/12, Fridge, 30
12/12/12, A/c, 40
12/12/12, TV, 60
13/12/12, Fridge, 70
13/12/12, LCD, 40

];

this is the output i want

Date, Properties, Value result
11/12/12, Fridge, 20,20
11/12/12, A/c, 30,30
12/12/12, Fridge, 30,50
12/12/12, A/c, 40,70
12/12/12, TV, 60,60
13/12/12, Fridge, 70,120
13/12/12, LCD, 40,40

];

i  have attached the qvw file here

11 Replies
nizamsha
Specialist II
Specialist II
Author

hi

i have attached a qvw file

nizamsha
Specialist II
Specialist II
Author

finally i got the output