Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

vardhancse
Valued Contributor III

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

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

1 Solution

Accepted Solutions

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

Try this

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

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

Try this

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

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

Hi @sunny_talwar ,

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