topic Re: Populate the values - In Script in QlikView

Populate the values - In Script

Anonymous — Wed, 14 Dec 2016 19:36:34 GMT

Hi Team,

I need to populate the score column(marked in red). I have used the count function(count (Score#)) in the script to populate the output of the value available in Score#(ie. 43). I need a solution in script to populate the Score column with all the values of quarter as same as Q1(ie 43). Please if anyone can help with the solution.

Qtr	Score #	Score
Q1-15	43	43
Q2-15	0	43
Q3-15	0	43
Q4-15	0	43
Q1-16	-	43
Q2-16	-	43
Q3-16	-	43
Q4-16	-	43

Re: Populate the values - In Script

vinieme12 — Wed, 14 Dec 2016 20:12:17 GMT

What if Q2-2015 was a greater number, what would you want then? please explain the exact basis of populating the nem column

Qtr	Score #	Score
Q1-15	43	43
Q2-15	50	43
Q3-15	0	43
Q4-15	0	43
Q1-16	-	43
Q2-16	-	43
Q3-16	-	43
Q4-16	-	43

Re: Populate the values - In Script

Anonymous — Wed, 14 Dec 2016 20:40:40 GMT

Hi Vineeth,

I understand that it can be many scenario, but in this case it would be only 1 value the one which am populating as per the business logic. Its customer requirement. There wont be any value going forward.

hope its bit clear now. Please let me know if its not.

Re: Populate the values - In Script

vinieme12 — Wed, 14 Dec 2016 20:47:43 GMT

Use the below, this is assuming your data is properly sorted.

LOAD Qtr,

[Score #],

if(RowNo()=1,[Score #],Peek(Score)) as Score

FROM

[https://community.qlik.com/thread/243395]

(html, codepage is 1252, embedded labels, table is @1);

Re: Populate the values - In Script

Anonymous — Wed, 14 Dec 2016 21:16:15 GMT

Thanks Vineeth.

Re: Populate the values - In Script

MarcoWedel — Wed, 14 Dec 2016 22:16:39 GMT

Hi,

another solution might be:

table1:
LOAD Dual(Qtr,AddMonths(Date#(Right(Qtr,2),'YY'),(Mid(Qtr,2,1)-1)*3)) as Qtr,
    [Score #]
FROM [https://community.qlik.com/thread/243395] (html, codepage is 1252, embedded labels, table is @1);
Join
LOAD FirstSortedValue([Score #],Qtr) as Score Resident table1;

hope this helps

regards

Marco

Re: Populate the values - In Script

Anonymous — Thu, 15 Dec 2016 14:15:33 GMT

Thanks Marco.. Even this solution is working..

Your solution are always unique!! Thank You!!!

Re: Populate the values - In Script

MarcoWedel — Thu, 15 Dec 2016 21:36:22 GMT

thanks

glad you like it.

regards

Marco