topic Re: Problem with scripting in QlikView

Problem with scripting

josephinetedesc — Sat, 16 Nov 2024 04:57:10 GMT

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

jyothish8807 — Mon, 17 Dec 2018 06:38:24 GMT

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 ?

josephinetedesc — Mon, 17 Dec 2018 06:48:55 GMT

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

Anil_Babu_Samineni — Mon, 17 Dec 2018 07:13:45 GMT

In Qlik also we can use like

=If(Field1=Field2, If(IsNull(Field1), 'delete', 'ok'))

jyothish8807 — Mon, 17 Dec 2018 07:45:06 GMT

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
];

josephinetedesc — Mon, 17 Dec 2018 09:18:23 GMT

on the same line - but I need to check the line above!

jyothish8807 — Mon, 17 Dec 2018 09:44:51 GMT

Hi,

I am checking the above value using 'previous' function in script.