topic Grouping data in Qlikview in QlikView

Grouping data in Qlikview

Fri, 12 Jun 2015 07:10:42 GMT

Hi Team,

I want to group data in Qlikview similar to the attached file. It is something like, I have one straight table and it gets repeated number of times depending on a field value (Ex: Country).

Can it be possible in Qlikview?

Thanks,

Umesh

Re: Grouping data in Qlikview

robert_mika — Fri, 12 Jun 2015 07:17:33 GMT

Do you mean repeated by Q?

or make the chart layout one under another?

Could you attached your app or post data?

Re: Grouping data in Qlikview

Fri, 12 Jun 2015 08:08:35 GMT

Yes, As shown in attached file, the straight table should repeat for each year. This is similar to sections in SAP BO.

I do not have a working copy since this is a POC that I am doing.

Thanks,

Re: Grouping data in Qlikview

buzzy996 — Fri, 12 Jun 2015 08:43:44 GMT

yes,defiantly can possible.

Re: Grouping data in Qlikview

robert_mika — Fri, 12 Jun 2015 08:57:38 GMT

I believe there is SAP connector to pull data from the system.

You can download your data.

Create the tables and add into container

Re: Grouping data in Qlikview

Fri, 12 Jun 2015 09:17:41 GMT

Ok, but I am still not convinced if container object can achieve it. Please see attached file which will help you to understand better.

Re: Grouping data in Qlikview

robert_mika — Fri, 12 Jun 2015 09:45:20 GMT

This is possible but your data must be split in the script or using VBS/JS to create that dynamically.

Re: Grouping data in Qlikview

Fri, 12 Jun 2015 10:58:05 GMT

Hi,

Can u plz explain how it will be possible.

Thanks in advance.