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: 
Evan0211
Creator II
Creator II

Mixing expression types

I am new to Qlik Sense and I have a bar chart that I am having some issues with.  

The dimension lists titles.  It is written as such:

=if(Match([OFFICE_CODE], $(vFilterOffice))
and
TimeStamp([Initial Date]) > today()
and
[Current Stage]='PA'
,[Title]&'-'&[List Title])

This works fine, however I need to add another variable to the expression, but the variable expresses in a different "format" (sorry I am not well versed on the terminology yet).

The variable expresses as:

{<Total Value] ={">=0"}>

Is there a way to add this kind of expression in the if statement?

Labels (1)
1 Solution

Accepted Solutions
Or
MVP
MVP

Your new expression appears to be a set analysis, which you will not be able to use in this context as there is no aggregation function being used.

If [Total Value] is a field, you could simply add a condition:

and [Total Value]>=0

However, if it is a calculation, you would likely need to add an aggr() function telling Qlik how to calculate Total Value in this context.

View solution in original post

1 Reply
Or
MVP
MVP

Your new expression appears to be a set analysis, which you will not be able to use in this context as there is no aggregation function being used.

If [Total Value] is a field, you could simply add a condition:

and [Total Value]>=0

However, if it is a calculation, you would likely need to add an aggr() function telling Qlik how to calculate Total Value in this context.