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: 
MRitter
Employee
Employee

What is this actually doing?

Count(TOTAL <$1> {<Year={"$(=Min(MinYear)+4)"}>} ClaimID)

I don't understand the impact the <$1> is having.

This is the actual entire statement.  I did not create this and want to understand it.

Thanks

If(Count(TOTAL <$1> {<Year={"$(=Min(MinYear))"}>} ClaimID)<>0,
Count(TOTAL <$1> {<Year={"$(=Min(MinYear))"}>} ClaimID),
If(Count(TOTAL <$1> {<Year={"$(=Min(MinYear)+1)"}>} ClaimID)<>0,
Count(TOTAL <$1> {<Year={"$(=Min(MinYear)+1)"}>} ClaimID),
If(Count(TOTAL <$1> {<Year={"$(=Min(MinYear)+2)"}>} ClaimID)<>0,
Count(TOTAL <$1> {<Year={"$(=Min(MinYear)+2)"}>} ClaimID),
If(Count(TOTAL <$1> {<Year={"$(=Min(MinYear)+3)"}>} ClaimID)<>0,
Count(TOTAL <$1> {<Year={"$(=Min(MinYear)+3)"}>} ClaimID),
If(Count(TOTAL <$1> {<Year={"$(=Min(MinYear)+4)"}>} ClaimID)<>0,
Count(TOTAL <$1> {<Year={"$(=Min(MinYear)+4)"}>} ClaimID),0
)))))

2 Replies
sunny_talwar

Is this an expression inside a variable? If it is, then you can read about this here Variables with Parameters

MRitter
Employee
Employee
Author

Yes, this is in a variable.  That helped me understand better.

What I am trying to do is make this chart unresponsive to any filters.  This variable is the denominator in an expression.  Everything that I have tried so far doesn't work.

The total expression is

(If (Year = Max(MaxYear),Count({<Industry=,Year={"<=$(=Max(MaxYear))>=$(=Min(MinYear))"} >} ClaimID) * vPercLeft,
Count({<Industry=,Year={"<=$(=Max(MaxYear))>=$(=Min(MinYear))"} >} ClaimID))
/
$(vTotalTrendDenominator(Actions)))-1

The expression I included in the first post is vTotalTrendDenominator

Thanks