topic Qlikview pivot chart - before in QlikView

Qlikview pivot chart - before

ssmhg2712 — Tue, 01 Jun 2021 13:24:08 GMT

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

Re: Qlikview pivot chart - before

ssmhg2712 — Mon, 14 Jun 2021 09:43:22 GMT

Hi,

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

Thank you very much!

Sven

Re: Qlikview pivot chart - before

Shawna12 — Wed, 30 Jun 2021 05:10:02 GMT

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?