Discussion board where members can get started with QlikView.
How can I have y axes showing as percent
If I try to change format setting from the Number tab the dual function will not work anymore,
so guess need a solution within the Dual function,
If(MyDate=Max(total MyDate), Name, ''),
Sum ([Grade])/Max(Total Aggr(Sum([Grade]), [Name]))
As I said:"If I try to change format setting from the Number tab the dual function will not work anymore,"
so in your solution we do not have the legend on the line of the Graph! but thanks for trying
Are you going to have this?
I have many observations , so do not want to show the percents on the line, but rather just the Legend at the end and the y axes as Percent
Created a second expression for putting the name
If you see for display option, Line is unchecked and only Values on Data Points is checked. This expression shows the name, while the first expression handles the axis and the line