topic Re: Grouping some field values - Chart in QlikView

Grouping some field values - Chart

sayadutt — Tue, 26 May 2015 10:07:04 GMT

Hi Team,

I am loading data from a sharepoint list, and the columns looks like this:

[Practice Area] , [Project Name]

11, aa

22, bb

33, cc

44, dd

Now my requirement is to merge [Practice Area] into one, if it belongs to 11 & 22

So my table should look like below:

[Practice Area] , [Project Name]

XX, aa

XX, bb

33, cc

44, dd

11 & 22 are now called as XX.

I don't want to rename this at Edit Script level, as other charts should continue showing them as 11 & 22.

Requirement is only for 1 chart (and merge should be done at individual chart level).

Please suggest.

Thanks

alexandros17 — Tue, 26 May 2015 10:15:48 GMT

It is not a grouping but a renaming so I can suggest an if condition in your expression or dimension

sayadutt — Tue, 26 May 2015 10:20:45 GMT

Can you please give me a sample expression.

Thanks

alexandros17 — Tue, 26 May 2015 10:22:56 GMT

in your dimension:

If([Practice Area]='11' or [Practice Area]='22', 'XX', [Practice Area])