topic Re: Displaying individual group information in QlikView

Displaying individual group information

Thu, 18 Jun 2015 20:21:37 GMT

Hi All,

I'd like to ask if is possible to display individual data for multiple selections.

For instance if you have a list of groups, individual users in that group, and their personal quantity of apples.

In Qlikview, Is it possible to have a table that lists all the members of a group and their individual # of apples?

Thanks Kindly

Re: Displaying individual group information

ramoncova06 — Thu, 18 Jun 2015 20:28:00 GMT

you can, though it depends on your data model

A Primer on Set Analysis

Set Analysis: syntaxes, examples

Re: Displaying individual group information

MarcoWedel — Thu, 18 Jun 2015 20:47:01 GMT

Hi,

can you please elaborate on your raw data and the expected presentation (table layout ...)

thanks

regards

Marco

Re: Displaying individual group information

Fri, 19 Jun 2015 13:59:34 GMT

Hey Marco,

I am looking for this below

However, Instead of the names, the ID, and the Personal Record all on different lines, I am looking for them all to line up in a row horizontally so you can quickly see information for each group and individual. However if there is a better way of doing this, please let me know!

Thanks for your help

Re: Displaying individual group information

Fri, 19 Jun 2015 14:00:21 GMT

Thanks Ramon,

I think this might apply but I have the documents under review and am currently looking for an answer!

Re: Displaying individual group information

awhitfield — Fri, 19 Jun 2015 14:13:51 GMT

Hi Thomas,

do you mean, like this?

Andy

Re: Displaying individual group information

Fri, 19 Jun 2015 14:20:17 GMT

Yes! Exactly like that!

However, I have about 200-300 groups in my data and I am only looking to display two groups and their members for comparison.

Say these two groups are always locked and the importance of these two trumps all others.

Is this possible as well?

Re: Displaying individual group information

Fri, 19 Jun 2015 14:29:11 GMT

And if so, what chart and properties should I use to display this?

Thanks!

Re: Displaying individual group information

awhitfield — Fri, 19 Jun 2015 14:37:25 GMT

Easiest what would be to just use and list box, then you can compare which ever you...

Andy

Re: Displaying individual group information

Fri, 19 Jun 2015 15:02:39 GMT

Alright I am having a little trouble applying this method to my data. Below is a better comparison of what I can use. Is it possible with this data as well?

Re: Displaying individual group information

Mon, 22 Jun 2015 13:27:13 GMT

Hi All,

I've been playing with different formats over the weekend, and I can't seem to get it narrowed down to the display as I described above. Could someone shed some light for me? My biggest problem is that there are so many groups involved and each of the individual members contain a large amount of personal performance data.

Thanks

Re: Displaying individual group information

pratap6699 — Mon, 22 Jun 2015 14:30:29 GMT

if(numberofapples>300,aggr(sum(numberofapples),team1,aggr(sum(numberofapples),team1)

Re: Displaying individual group information

awhitfield — Tue, 23 Jun 2015 08:19:55 GMT

Hi Thomas,

see attached, not sure if the expression is what you want though

Andy