topic Re: If condition not working correctly for all data in data load editor in App Development

If condition not working correctly for all data in data load editor

Amita — Mon, 14 Mar 2022 06:20:16 GMT

In data load editor while loading data created calculated column with if condition. It is a bulk data. When condition is executing for similar data some are satisfied and some are moving in default else condition. For some rows of data it is working properly.

is this a Qlik issue or need to change something in data load editor?

Re: If condition not working correctly for all data in data load editor

anat — Mon, 14 Mar 2022 07:38:35 GMT

if possible can u share the if logic what u r using- with some sample data

Re: If condition not working correctly for all data in data load editor

Amita — Mon, 14 Mar 2022 12:10:09 GMT

Hi Anat, My if logic is like:

LOAD
[A],
[B],
[C],
[D],
[E],
[F] ,
if(B >= C and C <= D,'No Issues',
if(C > B and C <= D,'Req S',
if(B = D and C > D,'Req C',
if(B < D and C > D,'S+C','Others')))) as STATUS,
if(C > B ,'E') as HEADLINE

FROM [lib://QVD/xyz.qvd](qvd)
where not isnull(XDate) ;

And attached sample data with STATUS column calculated . You can remove that run the logic.

1st row is satisfying condition "No issues" but still going in others.

I want to create a donut chart so for dimension i am creating a column STATUS in data load editor.

Thanks in Advance.

Re: If condition not working correctly for all data in data load editor

MarcoWedel — Mon, 14 Mar 2022 19:40:02 GMT

Your expression does not reproduce this behaviour loading your sample data, so I guess the issue lies rather with your qvd data.

table1: LOAD [A], [B], [C], [D], [E], If(B >= C and C <= D,'No Issues', If(C > B and C <= D,'Req S', If(B = D and C > D,'Req C', If(B < D and C > D,'S+C','Others')))) as STATUS FROM [lib://DataFiles/Qlik_Com_Sample_DATA.xlsx] (ooxml, embedded labels, table is Sheet2);

Re: If condition not working correctly for all data in data load editor

Amita — Tue, 15 Mar 2022 11:31:04 GMT

Thanks Marcowedel.

How we can verify QVD data. Because the sample data i have shared fetched from app only(QVD).

In DB one column is varchar and others are number. Because of varchar column QVD is behaving like this. For some rows it is satisfying condition and some for some rows not working?

Re: If condition not working correctly for all data in data load editor

Amita — Thu, 17 Mar 2022 06:04:20 GMT

I have resolved the issue by change varchar to num in Load statement. Now it is satisfying condition properly .

Thank you.