Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
viveksingh
Contributor II

Qlikview pick below dimension

Hi All,

I have data like below.

Qlik comm Aug 15.PNG

Expecting the result like below.

Qlik comm Aug 15 Expect.PNG

 

Labels (2)
5 Replies
viveksingh
Contributor II

Re: Qlikview pick below dimension

@sunny_talwar 

Can you please check on this

lockematthewp
Contributor II

Re: Qlikview pick below dimension

How are you determining which values need changed?

viveksingh
Contributor II

Re: Qlikview pick below dimension

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.

viveksingh
Contributor II

Re: Qlikview pick below dimension

Any inputs on this ?

Partner
Partner

Re: Qlikview pick below dimension

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:

Pick.PNG

Attached is the qvw which uses pick function in script.

Thanks and regards,

Arthur Fong