Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ashwin_r
Contributor III
Contributor III

By pass field selection is not working with if condition/pick match

Hello Everyone,

Below expression working fine.

sum({<[Link Date]={">=$(vCalMinDate)<=$(vCurrentDate)"},[Txn Type]={'Actual'},[Cost Center Level 2 TEXT]=>}Amount),

but when i use if condition then by-passing is not working on [Cost Center Level 2 TEXT] .

If(PerEquiVeh='Actual',sum({<[Link Date]={">=$(vCalMinDate)<=$(vCurrentDate)"},[Txn Type]={'Actual'},[Cost Center Level 2 TEXT]=>}Amount))

 

@swuehl@johnw@tresesco@sunny_talwar, @jagan  

Kindly suggest with your inputs on this.

 

Thanks,

Ashwin

Labels (1)
2 Replies
tresesco
MVP
MVP

I guess it could be something related to execution scope issue. Could you share a sample app to investigate?

sunny_talwar

Try this

If(Only({1} PerEquiVeh) = 'Actual', Sum({<[Link Date] = {">=$(vCalMinDate)<=$(vCurrentDate)"}, [Txn Type] = {'Actual'}, [Cost Center Level 2 TEXT]>} Amount))

Or this

If(Only({<[Cost Center Level 2 TEXT]>} PerEquiVeh) = 'Actual', Sum({<[Link Date] = {">=$(vCalMinDate)<=$(vCurrentDate)"}, [Txn Type] = {'Actual'}, [Cost Center Level 2 TEXT]>} Amount))