topic Re: Creating flags in load scripts in QlikView

Creating flags in load scripts

Tue, 11 Sep 2012 12:03:58 GMT

Hello

I have the first 4 columns, and i want to achieve the 5 (Highest version per Offnum) column.

OffNum OffLine Version Amount HighstVersion

1 1 1 10 0

1 2 1 15 0

1 1 2 9 1

1 2 2 14 1

2 1 1 4 1

2 2 1 9 1

Anybody has any idea how to do this?

Thanks

Re: Creating flags in load scripts

Jason_Michaelides — Tue, 11 Sep 2012 13:06:35 GMT

Do you want to do this in the load script where user-selections will not be accounted for, or in the UI based on user-selections?

Re: Creating flags in load scripts

Tue, 11 Sep 2012 13:22:23 GMT

We would like to do this based on user seletions in the UI.

Re: Creating flags in load scripts

Jason_Michaelides — Tue, 11 Sep 2012 13:25:38 GMT

Shouldn't your 5th column above be 2,2,2,2,1,1 ?

"2" is the highest version for OffNum 1, "1" is the highest version for OffNum 2.

Re: Creating flags in load scripts

Tue, 11 Sep 2012 13:30:18 GMT

Thats also possible, I was more thinking of a flag 1, 0 as True (this line has the highest version) or False.

Re: Creating flags in load scripts

Jason_Michaelides — Tue, 11 Sep 2012 13:38:26 GMT

Ah - OK. In that case, add this expression:

IF(Version=Max(TOTAL <OffNum> Version),1,0)

Hope this helps,

Jason

Re: Creating flags in load scripts

Tue, 11 Sep 2012 13:49:10 GMT

I am sorry, i do want it in the load script. Then this expression won't work I suppose.

Re: Creating flags in load scripts

Jason_Michaelides — Tue, 11 Sep 2012 13:53:53 GMT

If you put this in the load script it won't be affected by user selections. No problem to do it but I need some more information to help you. Can you provide a sample app?