topic Re: Ignore Dimension-Filter for If Statement in Pivot Table & Combo Chart in App Development

Ignore Dimension-Filter for If Statement in Pivot Table & Combo Chart

vardhancse — Sat, 16 Nov 2024 21:19:22 GMT

Hi,

I have one requirement, like ignore month and year filters for if condition expressions:

Expression:

IF(WildMatch(MonYY,'*18','Jan-19'),
Sum({<Type={'1'}>}Volume),
Count({<B={'1'}>}ID))

Tried:

Solution 1:

IF(WildMatch(MonYY,'*18','Jan-19'),
Sum({<Type={'1'},Year=,MonthName=>}Volume),
Count({<B={'1'},Year=,MonthName=>}ID))

Solution 2:

IF(WildMatch(MonYY,'*18','Jan-19'),
Sum({1<Type={'1'}>}Volume),
Count({1<B={'1'}>}ID))

but no luck

can any one let me know any solution for the same

Re: Ignore Dimension-Filter for If Statement in Pivot Table & Combo Chart

sunny_talwar — Fri, 01 Mar 2019 12:56:18 GMT

Try this

If(WildMatch(Only({<Year, MonthName>} MonYY), '*18', 'Jan-19'),
  Sum({<Type = {'1'}, Year, MonthName>} Volume),
  Count({<B = {'1'}, Year, MonthName>}ID)
)

Re: Ignore Dimension-Filter for If Statement in Pivot Table & Combo Chart

vardhancse — Mon, 04 Mar 2019 05:16:01 GMT

Hi @sunny_talwar ,

Worked perfectly and thank you so much, missed that point of using Only().