i have a calculate dimension in a trend line chart, with if statements, BUT my second if statement is giving me 0s. so if i switch the 1st if statement to the second position, i get incorrect values for it. so, in essence, it is only returning a correct value for whatever calculation is being done first.
the goal is: 489,546 in FY1, and 486,990 in FY2
i have never encountered this in qlik. any thoughts? (i could do them as expressions, but i want to change the bar chart to a trend chart)