# Qlik Sense App Development

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

Labels (2)

• ### ignore current selection

1 Solution

Accepted Solutions
Highlighted
MVP

## 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
Highlighted
MVP

## 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)
)```
Valued Contributor III

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

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