Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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

Tags (3)
Labels (1)
2 Replies
Highlighted
MVP
MVP

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

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

Highlighted

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

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))