topic Re: Trend line with % value as Data points in QlikView

Trend line with % value as Data points

pranaview — Sat, 16 Nov 2024 18:28:38 GMT

Hi Guys,

Requirement: So I have a field which has different teams on it and we have a KPI value in %. Now if that value for May-20 is 95% then i need to show the reason for the rest 5% which is basically the Team field. So just for the sake of example if i have 4 teams in the field then i want to show 4 different trend lines in the chart with Month being on the X-axis and 5% distributed among the 4 teams on the Y-axis.

I used an expression like below

Count({< Flag = {'0}>} ID)/Count({<Flag = {'0,'1'}>} Total <Month> ID)

Where Dimensions are Team and Month fields. This works unless i select a particular month in which case the 5% changes to relative %.

Hope i have made the requirement clear enough, any suggestion would be appreciated.

Thanks!

Re: Trend line with % value as Data points

Brett_Bleess — Thu, 02 Jul 2020 14:01:07 GMT

All but impossible for folks to try to help with the QVW in these cases, as we need to be able to see data model etc. in order to check fields you are using etc...

Regards,
Brett

Re: Trend line with % value as Data points

pranaview — Thu, 09 Jul 2020 06:21:35 GMT

Hi Brett,

I got it done by using multiple expressions instead of that single dimension so i think we can close this thread.

Thanks!

Pranav