topic Re: How and where to write conditional statement in qlikview in QlikView

How and where to write conditional statement in qlikview

trishita — Wed, 25 Nov 2020 16:16:04 GMT

I have two fields .

Deviation after sounding and Difference vs Log survey:

I want to write a code that if the difference between them is less than 2 then a new column will display yes against the value or else no.

if (Deviation after sounding) - (Difference vs Log survey) <=2 then (NEW COLUMN ) = "Correction done"

or else "Correction Not Done"

Re: How and where to write conditional statement in qlikview

m_woolf — Wed, 16 May 2018 16:03:26 GMT

In script:

if(rangesum([Deviation after sounding],-[Difference vs Log survey])<=2,'Correction done','Correction not done') as NewField

Re: How and where to write conditional statement in qlikview

vishsaggi — Wed, 16 May 2018 16:03:38 GMT

Did you try like:

LOAD field1, field2,

if ((Deviation after sounding - Difference vs Log survey) <=2, "Correction done", "Correction Not Done") AS NewFieldName

FROM yoursourceTableName;

Re: How and where to write conditional statement in qlikview

trishita — Wed, 16 May 2018 16:11:01 GMT

I have not done it in the table as the two fields are coming from different tables

Re: How and where to write conditional statement in qlikview

trishita — Wed, 16 May 2018 16:12:52 GMT

Why do we need rangesum? Can I do it in the edit expression of chart properties(as I am using a standard table chart)

Re: How and where to write conditional statement in qlikview

m_woolf — Wed, 16 May 2018 16:18:43 GMT

You need rangesum if either of the two fields can ever be null. F1-F2 will yield null if either is null.

Yes, you can do it in a chart expression. Generally it is better (faster) to do as many calculation is script as is feasible.

Re: How and where to write conditional statement in qlikview

trishita — Wed, 16 May 2018 16:38:41 GMT

Hi I tried with the following code:

if(rangesum(SoundingCorrections.DEVIATION_AFTER_SOUNDING,-[Summary.Difference Log vs Survey])>= 0,'Correction done','Correction not done')

DEVIATION AFTER SOUNDING HAS THE FOLLWOING VALUES. = -42, -42, -42, -42

Difference Log vs Survey HAS THE FOLLWOING VALUES = 0, -42.68, -16, -7.89

But for all the values they are showing 'Correction Not Done' Which should not be true as the second value is clearly greater than 0

Re: How and where to write conditional statement in qlikview

m_woolf — Wed, 16 May 2018 16:58:45 GMT

Add an expression:

rangesum(SoundingCorrections.DEVIATION_AFTER_SOUNDING,-[Summary.Difference Log vs Survey])

so you can see the values.

Can you share the qvw?

Re: How and where to write conditional statement in qlikview

vishsaggi — Wed, 16 May 2018 17:34:51 GMT

Can you share your data model and the script you are trying?

Re: How and where to write conditional statement in qlikview

shiveshsingh — Thu, 17 May 2018 05:01:50 GMT

Can you share the data and script?

Re: How and where to write conditional statement in qlikview

aslam24196 — Thu, 17 May 2018 05:50:54 GMT

You can wirte this in the expression if you want to do it in the front end:

if(([Deviation after sounding] - [Difference vs Log survey]) <=2,'Correction Done','Correction Not Done')