topic Re: drawing a bar chart which it dimension include 5 main groups and two maximum of the last group in QlikView

drawing a bar chart which it dimension include 5 main groups and two maximum of the last group

Mkh13646 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all, I have a dataset like below picture which includes some account and their groups, periods, and their amounts and I would like to draw a bar chart which it's dimension include the sum of my 3 main account group in each year plus two maximum sums of account in the third group, then drill down to company, is there any way to extract the two maximum account from the third group and draw them beside the three main group?

My chart should include sums of amounts of group A, B and C for each year, and sums of the maximum amount of two accounts in group C

Re: drawing a bar chart which it dimension include 5 main groups and two maximum of the last group

Brett_Bleess — Wed, 25 Mar 2020 21:09:45 GMT

Best I have as a point in the possible right direction is the following, not sure if it will work or not, but pretty sure that is where you need to head with this one.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Server/Content/QV_Server/QlikView-Server/QVSRM_PublisherTriggeringEDXEnabledTasks.htm

Here is the base URL to the Design Blog area if you want to do some further searching on your own:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett