topic Re: IF STATEMENT USING VARIABLES in QlikView

IF STATEMENT USING VARIABLES

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

Hello Experts

I am trouble with my IF Statement using as condition.

I have created 3 variables to be as measures.

vPresenttax - this sum up the actual tax withheld
vTaxDue - this calculates for annual tax
vstilldue_refund - this is the difference between vTaxDue - vPresenttax

What I am trying to achieve is to create a measure

Still Due
Refund

using if statement.

To check if vstilldue_refund has value I created a measure called Still Due / Refund (Positive amount still due and negative amount Refund). When I place the measure in my sheet its giving a positve value when vTaxdue is greater than vpresenttax, and negative value when vtaxdue is less than vpresenttax.

But when put it in another measure with if statement there is no result.

Measure Still Due = if($(vstilldue_refund) > 0, $(vstilldue_refund),0) this giving no result.

Measure Refund = if($(vstilldue_refund) < 0, $(vstilldue_refund)*-1,0) this giving no result.

Please help.

Thank you

Re: IF STATEMENT USING VARIABLES

Anil_Babu_Samineni — Mon, 01 Jan 2018 06:20:46 GMT

Can you describe more without Variables.

Re: IF STATEMENT USING VARIABLES

vannieariola — Mon, 01 Jan 2018 08:37:15 GMT

Hi Anil,

vstilldue_refund= $(vtaxdue) - $(vpresenttax)

Measure

STILL DUE / (REFUND) = $(vstilldue_refund)

When I put this measure in my pivot table there is value. Meaning the variable is working fine.

Re: IF STATEMENT USING VARIABLES

Anil_Babu_Samineni — Mon, 01 Jan 2018 08:40:31 GMT

Image please for that without selection?

Re: IF STATEMENT USING VARIABLES

vannieariola — Mon, 01 Jan 2018 09:02:25 GMT

Hi Anil,

Here's the image you requested.

I appreciate your help.

Thank you.

Re: IF STATEMENT USING VARIABLES

pradosh_thakur — Mon, 01 Jan 2018 09:16:03 GMT

Hi Vannie

I tried something similar and that is working for me . Can you please just delete the label of the two column and hover the cursor on the top/header of the two column in the table. you can see the resulting expression can you please paste that screenshot please ?

Re: IF STATEMENT USING VARIABLES

Anil_Babu_Samineni — Mon, 01 Jan 2018 10:11:53 GMT

Are you working this in KPI/Text box?

Re: IF STATEMENT USING VARIABLES

vannieariola — Wed, 03 Jan 2018 00:31:30 GMT

Re: IF STATEMENT USING VARIABLES

Anil_Babu_Samineni — Wed, 03 Jan 2018 02:16:49 GMT

Will u provide 2 different variables using measure?

Re: IF STATEMENT USING VARIABLES

pradosh_thakur — Wed, 03 Jan 2018 04:07:11 GMT

Hi Vannie

what we meant is not in the edit mode. First delete the column headers/label for the column that value is not showing. then Click done . Then go and hover on the label of the column . something lime this.