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: 
Not applicable

Comparative Analysis

Sorry, I'm new user QV.

On this instrucción

sum({$ <DATE = {$(#=only(DATE)-1)}>} CASH)

how I can add a condition (for example the state of one registration)?

which would be the syntax?

1 Solution

Accepted Solutions
erichshiino
Partner - Master
Partner - Master

You may include as many fields as you want:

sum( { < STATE = {'TEST'}, SOURCE = {'SYSTEM'}, DATE = {$(#=only(DATE)-1)}> } CASH)

View solution in original post

2 Replies
erichshiino
Partner - Master
Partner - Master

You may include as many fields as you want:

sum( { < STATE = {'TEST'}, SOURCE = {'SYSTEM'}, DATE = {$(#=only(DATE)-1)}> } CASH)

Not applicable
Author

Thanks Erich!, this is needed to know.