Set Analysis Data Format Issue?

[dhamilton]

I am trying to run a basic set analysis in a bar chart that shows the total dollar amount of invoices no longer outstanding, and each bar is a different reason it is no longer outstanding ([Off Aging]='Yes'), (paid, written off etc.); so Dimension= [Off Aging Reason], Measure= Original Amount Outstanding.

There is a filter for Off Aging. When this is set to "No", then no longer amounts should be shown in the chart. To get this to work properly I have been trying to use the following Equation:

Sum({<[Off Aging]={'Yes'}>} [Original Amt])

The chart however shows the total dollar amount per each category whether Off Aging is Yes or No, and does not change when the filter is adjusted.

This Qliksense loads data from a .qvd, and in that .qvd I perform the following transformation:

if([Off Aging]='1','Yes','No') as [Off Aging],

I believe the reason this isn't working properly is because the resulting data of this transformation is in an incorrect format for the set analysis to work correctly (this is the only difference between the set analyses I have working correctly and this one).

Can anyone assist with how I can fix this issue?

Thank you!

[rwunderlich]

Your set modifier

<[Off Aging]={'Yes'}>

means "Ignore any filter in [Off Aging] and act as if "Yes" was selected".  If you want to suppress the measure value when [Off Aging] = No is selected, you want an expression like:

If (Only([Off Aging]) <> 'No', Sum({<[Off Aging]={'Yes'}>} [Original Amt]))

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[MayilVahanan]

Hi

If you select "NO" in the filter, then below expression gives zero, else provides yes amount

Sum({<[Off Aging]*={'Yes'}>} [Original Amt])