Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Calculated Dimension

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.

Expression: count(personnel)

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)

Dimension in the 1st bar chart:

=if(fiscalyear1headcount=1 , 'FY1',
IF(fiscalyear2headcount=1 , 'FY2',
IF(fiscalyear3headcount=1, 'FY3')))

Dimension in the 2nd bar chart:

=if(fiscalyear2headcount=1 , 'FY2',
IF(fiscalyear1headcount=1 , 'FY1',
IF(fiscalyear3headcount=1, 'FY3')))

persons.PNG

 

1 Reply
Highlighted

Would you be able to share a sample qvw to check this out? Also, what numbers do you expect to see (for the attached sample) for all the three bars?