Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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