Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.