Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I would like to have a table of all (parent) records with their (child) notes.
Doing it my way (as shown below )I get into a problems:
For exmaple
rec1 - does not have a note and I want to show that
rec2 - has 2 notes I do not want to show the line which shows that it does not have a note.
What I want is:
if a Record has a note - show this
if a Record has not got a note - show this
if a Record has a note ignore the the indicator that says no note
Thank you for your help
Jo
Hi Joseph,
In the below example which value should be considered as 'no note' ?
Could you please share the expected output clearly in the required format ?
Hi KC
the lines with the yellow highlight are the problem:
In excel I used the following formula:
if the cell below is the same as the cell above and if the cell is blank - "delete" and then manually delete that line
'=IF(E1987=E1986,IF(ISBLANK(F1987),"delete","ok"))
thank you
Jo
In Qlik also we can use like
=If(Field1=Field2, If(IsNull(Field1), 'delete', 'ok'))
Hi Joseph,
Please try this aswell.
Load
Record,
Note,
if((Record=Previous(Record) and Note='nx') or (RowNo()=1 and Note='nx'),'',Note) as New_Note;
LOAD * INLINE [
Record, Note
rec1, nx
rec2, notea
rec2, noteb
rec2, nx
rec3, notec
rec4, noted
rec5, notee
];
Hi
on the same line - but I need to check the line above!
Jo
Hi,
I am checking the above value using 'previous' function in script.