topic Re: IF() overruling Set Analysis? in App Development

IF() overruling Set Analysis?

Anonymous — Mon, 26 Jun 2017 12:53:10 GMT

Hi all,

I'm in doubt if I'm doing something wrong.

I have a table with dimensions and measures. On the measure I have a Set Analysis that limits the date range to last three months. All is working fine, no problem, data is only shown for the last three months.

Then I add a cell color condition with a IF-statement and then all rows are shown. It's like the Set Analysis is overrulled by the IF statement.

What I'm I doing wrong?

Br Thomas

Re: IF() overruling Set Analysis?

CarlosAMonroy — Mon, 26 Jun 2017 12:56:22 GMT

Hi Thomas,

If you are using the same expression in the color condition you must add the same set analysis in order to keep the same data shown.

Carlos M

Re: IF() overruling Set Analysis?

Anonymous — Mon, 26 Jun 2017 12:59:53 GMT

Hi carlosamonroy‌,

Okay, but how would you construct a calculation that uses Set Analysis and chooses a color depending on comparison?

Br Thomas

Re: IF() overruling Set Analysis?

sunny_talwar — Mon, 26 Jun 2017 13:04:06 GMT

Would you be able to share the expression you are using right now?

Re: IF() overruling Set Analysis?

CarlosAMonroy — Mon, 26 Jun 2017 13:07:02 GMT

The same way you are doing it in the expression.

Measure:

sum({<Field1={'abc'},Field2={'def'}>}Value)

Color condition:

if(sum({<Field1={'abc'},Field2={'def'}>}Value) > 90,RGB(255,0,0),RGB(0,255,0))

Re: IF() overruling Set Analysis?

Anonymous — Mon, 26 Jun 2017 13:15:06 GMT

Thanks carlosamonroy‌

Re: IF() overruling Set Analysis?

Anonymous — Mon, 26 Jun 2017 16:42:05 GMT

carlosamonroy‌, I stand corrected, it doesn't work

Here's the code:

gvCurrentMonthM3FirstDate = 01-03-2017

gvLastMonthLastDate = 31-05-2017

Measure

=Sum({$<[Created date]={'>=$(gvCurrentMonthM3FirstDate) <=$(gvLastMonthLastDate)'}>}([Month lengh]-[Solution duration])/[Month lengh])

Text condition

If(Sum({$<[Created date]={'>=$(gvCurrentMonthM3FirstDate) <=$(gvLastMonthLastDate)'}>}([Month lengh]-[Solution duration])/[Month lengh])<Target, Red(),Green())

The last four lines should not be shown.

Re: IF() overruling Set Analysis?

sunny_talwar — Mon, 26 Jun 2017 16:47:13 GMT

May be uncheck 'Include zero values' under Add-Ons -> Data handling

Re: IF() overruling Set Analysis?

CarlosAMonroy — Mon, 26 Jun 2017 16:47:35 GMT

Can you try using the following expression:

=Sum({$<[Created date]={'>=$(gvCurrentMonthM3FirstDate) <=$(gvLastMonthLastDate)'}>}[Month lengh]-[Solution duration])

Sum({$<[Created date]={'>=$(gvCurrentMonthM3FirstDate) <=$(gvLastMonthLastDate)'}>}[Month lengh])

Re: IF() overruling Set Analysis?

Anonymous — Mon, 26 Jun 2017 18:48:30 GMT

That's the one. Thx stalwar1‌