topic Re: Inert row in Fact Table in QlikView

Inert row in Fact Table

Mon, 14 Jan 2013 12:37:29 GMT

Hi Guys,

Can any1 try out how to add a dynamic row within a fact table.

In my attachment i have given the raw data in "Data Sheet" & the output required in another sheet.

Thanks for help 🙂

Rgds,

Srini

Re: Inert row in Fact Table

ToniKautto — Mon, 14 Jan 2013 13:38:12 GMT

What exactly is the issue you are observing?

Are you intending to load the two sheets and want to know how to only load the additional row from the second sheet?

Is the question about how to add one row to an existing table?

Re: Inert row in Fact Table

Mon, 14 Jan 2013 16:23:03 GMT

Hi,

Thanks, just to give you some background.

If you see the first sheet in excel is the Raw data to be loaded in to qlikview & the "Output Required" is the sheet thats what i am trying to acheive from the script but not in front end expression.

Its the cummulative figure month on month.

In my case as per the first Excel sheet "Data" there is not record for May 2012, hence i need to insert dynamically a to get the May 2012 YTD (Apr 2012 + May 2012) as well and then for Jun 2012 it will be (Apr 2012 + May 2012 + Jun 2012) and on and on...

hope i am able to clear the doubt

Rgds,

srini

Re: Inert row in Fact Table

Gysbert_Wassenaar — Mon, 14 Jan 2013 17:58:55 GMT

See attached example.

edit: added updated example

Re: Inert row in Fact Table

Mon, 14 Jan 2013 18:21:10 GMT

Thanks once again for your help 🙂

just guessing if this will work for a 1 Million rows in a single fact table, where as i have close to 17 such fact tables where in i have to apply this logic.

Re: Inert row in Fact Table

Tue, 15 Jan 2013 05:52:31 GMT

Hi Gysbert,

Just need one more help from you, in case if i have the data in the attached format & can your script run on every unique Key (its combination of GL Code, Company Code, State Code and Brand Code) and the Month on Month Accumulation should happen on every unique Key.

Hence i have also given the output required in the second sheet.

can you share your though process on it.

Thanks in advance 🙂

Rgds,

srini

Re: Inert row in Fact Table

sujeetsingh — Tue, 15 Jan 2013 06:46:26 GMT

gysbert a quick and to the point solution...keep it up

Re: Inert row in Fact Table

Tue, 15 Jan 2013 08:27:38 GMT

Thanks Guys... Have done it, infact there is one more rule to be written on top of the above req, as it has to run for every Fiscal year wise for each Unique Key.

Srini