topic Re: Nested If Statement in QlikView

Nested If Statement

Wed, 05 Aug 2015 16:53:25 GMT

Can someone please help me with this formula? Something is wrong with the conditional argument because the final false argument is always what displays. I have tested this by commenting out line 4, which results in a chart that says no data to display.

=IF($(vAggLevel) = 'Total Amount',

MONEY(SUM({$<[USD:Approved]={">$(PopHighDollar)"}>} [USD:Approved])),

IF($(vAggLevel) = 'Transaction Count',

NUM(COUNT({$<[USD:Approved]={">$(PopHighDollar)"}>} [Report_Entry]),'##,###'),

MONEY(SUM({$<[USD:Approved]={">$(PopHighDollar)"}>} [USD:Approved]))

)

vAggLevel is defined as

GetFieldSelections(Level)

The Level field only has 2 values "Total Amount" and "Transaction Count"

I have used the same formula on a different chart and it works fine. This only difference is the True statement. In the chart that works I have a standard SUM or COUNT, where as in this one I am using set analysis.

I also have a text box that dispays vAggLevel to make sure the variable is getting populated correctly.

Any suggestions?

Re: Nested If Statement

Gabriel — Wed, 05 Aug 2015 17:09:34 GMT

Hi,

What does this gives you in return

vAggLevel is defined as

GetFieldSelections(Level)?

Re: Nested If Statement

sasiparupudi1 — Wed, 05 Aug 2015 17:41:52 GMT

since you only have 2 values in the variable,one if should be sufficient

IF($(vAggLevel) = 'Transaction Count', NUM(COUNT({$<[USD:Approved]={">$(PopHighDollar)"}>} [Report_Entry]),'##,###'),

MONEY(SUM({$<[USD:Approved]={">$(PopHighDollar)"}>} [USD:Approved]))

hth

Sasi

Re: Nested If Statement

Michiel_QV_Fan — Fri, 04 Sep 2015 13:28:41 GMT

Jessica,

You can use Stefan Walthers nested if tool here: http://www.qlikblog.at/464/tool-creating-nested-ifstatements/

Re: Nested If Statement

Mon, 21 Mar 2016 08:51:25 GMT

Sorry to bring up an old thread, but I am also having the same issue.

I'm using an IF statement on a chart which changes its dimension in respect of a variable button. The variable button allows the field on the chart to change from CalendarYear, CalendarYearQtr, and MonthYear. The IF statement works fine when it's not nested. For example:

IF($(vDateDisplay) = CalendarYear, Example1, Example2)

However, once the If statement is nested it only displays the false argument. For example:

IF($(vDateDisplay) = CalendarYear, Example 1,

IF($(vDateDisplay) = CalendarYearQtr, Example2,

Example 3))

If this a known issue in Qlik Sense?

Re: Nested If Statement

PradeepReddy — Mon, 21 Mar 2016 08:53:31 GMT

can u provide the sample app?

Re: Nested If Statement

Mon, 21 Mar 2016 08:56:14 GMT

I'm not able to sorry due to sensitive data. And it's a Qlik Sense app, only realised that this was a Qlik View thread sorry.