Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

get next values if NULL

Hi all,

Table 1:

EMPLIDSTRMGPA
115200.000
115303.750
116103.940
116203.940
116304.040
117104.040
118103.400
118203.400
11830NULL

This will be done in the loading script. What i want to be able to do is to get the GPA from MAX(STRM)  if it is not null.

Let me elaborate. If there is a value in 1830 , then pick up the GPA from there.

In this scenario, where the GPA in the highest STRM 1830 is null, i want to be able to get the GPA of 3.400 from STRM 1820.

Desired Output:

EMPLID      STRM      GPA

1                   1820       3.4

Any form of help is greatly appreciated.

Thank you for your time!

Tags (3)
1 Reply
Highlighted
Creator
Creator

Re: get next values if NULL

Data:

load * Inline

[

EMPLID,STRM,GPA

1,1520,0.000

1,1530,3.750

1,1610,3.940

1,1620,3.940

1,1630,4.040

1,1710,4.040

1,1810,3.400

1,1820,3.400

1,1830,NULL

];

right join(Data)

Data1:

load EMPLID,

max(STRM) AS STRM

RESIDENT Data where GPA<>'NULL' group by EMPLID;