Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Evan0211
Creator
Creator

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.