Qlikview pivot chart - before

[ssmhg2712]

Dear all,

I have a problem with a pivot chart, where the basis data is not complete for every record, as the user changes only these values which are really changing.

Therefore I use "before" in the pivot chart:

if(isnull(price), before(price,1),price)

This works exactly for one column 😉

But I need a function which works as a kind of a loop to get a value for the following columns, till a new value is available.

Do you see in chances to solve this in a chart or do I have to reorganize the data structure.

Thank you very much!!!
Kind regards, 

Sven

[ssmhg2712]

Hi,

does anybody have an idea to solve the "before" problem?

Thank you very much!

Sven

[Shawna12]

I'm freelancing a little until the end of my education. I found a company that would hire me for a few days per month. Here is what will expect me:

They have a few different systems. All backed by some kind of RDMS. And there is a QlikView installation. Nothing more. QlikView is not configured to do anything, it's just installed on a dedicated server.

Tney need a few reports, by aggregating data from different sources. They also want something like a daily export of the data.

I have no QlikView experience, but would like to tackle the job. Are there any resources online to educate myself?

www.myloweslife.com