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: 
prabunakil
Contributor III
Contributor III

Expression

Hi all, please assist to share the expression.

My criteria is as per below:

1. [Bill Type] = {'ZLF2'}, [KSCHL]={'Z1PR'}

2. [Billing Item] = [Billing Item2]

3. Sum [KONV_KWERT]

13 Replies
prma7799
Master III
Master III

Try this

Sum( {<[Billing Item] = {'[Billing Item2]'} , [Bill Type] =  {'ZLF2'} ,[KSCHL]={'Z1PR'} >}  [KONV_KWERT])

qlikviewwizard
Master II
Master II

Hi,

Attach some sample data.

prabunakil
Contributor III
Contributor III
Author

Sample File.png

this is the database. i want to link that two field together.

prabunakil
Contributor III
Contributor III
Author

answer return error. no matching.

prma7799
Master III
Master III

what error you are facing ?

prabunakil
Contributor III
Contributor III
Author

it show zero.

prabunakil
Contributor III
Contributor III
Author

Sample File.png

i want to compare this two field and match it.

prabunakil
Contributor III
Contributor III
Author

Hi any solution?

prma7799
Master III
Master III

Please share QVW file