topic Re: Dynamically insert a calculate row in table in QlikView

Dynamically insert a calculate row in table

Sun, 13 Jul 2014 11:30:32 GMT

Hi Guys,

I have a table with following structure in qlikview. (This is the table that I am creating from my source data at front end )

Head Budget

Revenue 1000

Material 1500

I want to add third row in my table Revenue% as Revenue/Material. How to add this row dynamically in my table.

Kindly help me Its little bit urgent

Tribhuwan

Re: Dynamically insert a calculate row in table

preminqlik — Sun, 13 Jul 2014 14:01:45 GMT

hi there, if i understood,

take dimension as calculated as given below :

ValueList('$(=concat(if(aggr(sum(Budget),Head),Head),chr(39)&','&chr(39)))','R/M')

expression:

sum(if(ValueList('$(=concat(if(aggr(sum(Budget),Head),Head),chr(39)&','&chr(39)))','R/M')=Head,Budget,$(=sum({<Head={'Revenue'}>}Budget)/sum({<Head={'Material'}>}Budget))))

once try above one let me know

@premhas

Re: Dynamically insert a calculate row in table

preminqlik — Sun, 13 Jul 2014 14:19:50 GMT

here is the another way