topic Re: Qlikview pick below dimension in QlikView

Qlikview pick below dimension

viveksingh — Sat, 16 Nov 2024 20:15:45 GMT

Hi All,

I have data like below.

Expecting the result like below.

Re: Qlikview pick below dimension

viveksingh — Thu, 15 Aug 2019 15:38:42 GMT

@sunny_talwar

Can you please check on this

Re: Qlikview pick below dimension

lockematthewp — Thu, 15 Aug 2019 15:43:48 GMT

How are you determining which values need changed?

Re: Qlikview pick below dimension

viveksingh — Thu, 15 Aug 2019 15:54:43 GMT

Condition 1:

If Dept-In is 'Default' and if status of previous record is 'Create' then the Default value should change to previous value in Dept_In.

Condition2:

if Dept-Out is 'Default' and Dept-In is 'Default' in next record, then it should replace below value of Dept-out in Dept-Out. and for Dept-In also should replace with below value of Dept-In.

Re: Qlikview pick below dimension

viveksingh — Fri, 16 Aug 2019 06:49:44 GMT

Any inputs on this ?

Re: Qlikview pick below dimension

Arthur_Fong — Fri, 16 Aug 2019 07:52:12 GMT

Hi,

It seems that you missed out one logic which will reduce the original 7 rows to 6 rows but here is the result with 7 rows:

Attached is the qvw which uses pick function in script.

Thanks and regards,

Arthur Fong