topic Re: help with field value grouping in QlikView

help with field value grouping

hopkinsc — Fri, 27 Jun 2014 16:27:12 GMT

Hi,

I have a field in my table that i want to make a grouping of...

Table 1:

Field A,

Field B,

Field C,

Field D,

Name,

From.....

the Name field has a list of names, and the RG field is a flag of Y.. eg..

Name RG

Name A Y

Name B

Name C Y

Name D

Name E Y

Name F Y

Name G

Name H

I want to group the names with an RG flag against them and rename them something else (NAME RG)

So i want to end up with a Name field that will show all of the names, plus the new value of NAME RG. i can then select either the individual names or the NAME RG which will make a selection on all of the RG Names.

Does that make sense?

Re: help with field value grouping

vgutkovsky — Fri, 27 Jun 2014 16:51:53 GMT

Not quite sure why you'd want to do this (seems like you can probably accomplish what you need by referencing the RG flag from set analysis in the front end) but the syntax is: if(RG='Y',Name) as [Name RG]

Regards,

Vlad

Re: help with field value grouping

hopkinsc — Fri, 27 Jun 2014 17:06:58 GMT

Hi, i dont want this in a chart. i want a list box to show all names PLUS a new value for the grouping.

I can then select the new grouping value from the list box and see all data relating to the RG names.

my new field will look something like ..

Name A

Name B

Name C

Name D

Name E

Name F

Name G

Name H

NAME RG

thanks

Re: help with field value grouping

vgutkovsky — Fri, 27 Jun 2014 17:24:07 GMT

Still seems to me like the easiest way to do this would just be to create a list box of flag RG. However, if you have your heart set on this solution, you'd need to create a separate table which will take you to a different granularity:

//First, load all names

Names:

LOAD

Name, //key to your existing table

Name as [Names (new)] //new field that will be displayed as a listbox

RESIDENT Table1;

//Then, add on values for RG names

CONCATENATE (Names) LOAD

Name, //key to your existing table

'Name RG' as [Names (new)] //new field that will be displayed as a listbox

RESIDENT Table1

WHERE RG='Y'

;

Regards,

Vlad