topic Re: How to give common name in pivot table? in QlikView

How to give common name in pivot table?

Shubham_Deshmukh — Tue, 03 Oct 2017 05:58:01 GMT

I am using pivot table ,this is what I am doing

What I want is,

Pls help

Re: How to give common name in pivot table?

its_anandrjs — Tue, 03 Oct 2017 06:13:37 GMT

Create the bucket for this in load script or create the calculated dimension.

Load

Mid(FieldName,3,1) as XBucket

From Source;

On UI

Mid(FieldName,3,1)

Note:- suppress when null selection to be done

Re: How to give common name in pivot table?

Shubham_Deshmukh — Tue, 03 Oct 2017 06:19:29 GMT

Sorry, I am not getting your 1st point.

I cant take calculated dimension at this stage in report.

Re: How to give common name in pivot table?

its_anandrjs — Tue, 03 Oct 2017 06:24:05 GMT

From seeing your data i believe data should be

A(X)

B(X)

C(X)

Then i suggest in load script create the bucket Mid(FieldName,3,1) as XBucket by this you get X from A(X), B(X) etc

Or else provide sample data.

Re: How to give common name in pivot table?

Shubham_Deshmukh — Tue, 03 Oct 2017 06:33:48 GMT

A,B,C nad x are not the data , they are just names of expressions

Re: How to give common name in pivot table?

its_anandrjs — Tue, 03 Oct 2017 06:37:41 GMT

Sample Data required then.

Re: How to give common name in pivot table?

prat1507 — Tue, 03 Oct 2017 08:28:46 GMT

so you can rename your expressions to A, B and C. Add a calculated dimension ='x' in the first field.

Regards

Pratyush

Re: How to give common name in pivot table?

Shubham_Deshmukh — Tue, 03 Oct 2017 09:47:01 GMT

Ya it works, but my table is like

so name1 is possible but in same table what about name2?

Re: How to give common name in pivot table?

prat1507 — Tue, 03 Oct 2017 09:57:45 GMT

Is there any point for differentiation between A(name1) and A(name2)?

Regards
Pratyush

Re: How to give common name in pivot table?

Shubham_Deshmukh — Tue, 03 Oct 2017 10:02:04 GMT

Ya, bcoz everytime I have to write it in bracket

i.e. A,B,C,D comes under X category. So I want to show like this.

But I am doing like A(X),B(X),C(X),D(X)

Re: How to give common name in pivot table?

Shubham_Deshmukh — Tue, 03 Oct 2017 10:02:32 GMT

And they all are just names.

Re: How to give common name in pivot table?

prat1507 — Tue, 03 Oct 2017 10:06:59 GMT

But what are name1 and name2? Is your data classified on the basis of name1 or name 2?

Regards
Pratyush

Re: How to give common name in pivot table?

prat1507 — Tue, 03 Oct 2017 10:08:27 GMT

Create an inline table as

Tab1:

Load * inline [

Fld1, Fld2

name1, A

name1, B

name1, C

name2, A

name2, B

name2, C

];

Use Fld1 and Fld2 in your dimensions.

Regards
Pratyush

Re: How to give common name in pivot table?

Shubham_Deshmukh — Tue, 03 Oct 2017 10:37:23 GMT

yaa, exactly

Re: How to give common name in pivot table?

Shubham_Deshmukh — Tue, 03 Oct 2017 10:55:23 GMT

But my dimension is months and my table is PIVOT, I am using this dimension as columns

Re: How to give common name in pivot table?

prat1507 — Tue, 03 Oct 2017 10:59:13 GMT

You can use multiple dimensions in Pivot!!

Regards

Pratyush

Re: How to give common name in pivot table?

prat1507 — Tue, 03 Oct 2017 10:59:42 GMT

Please share a sample data and your desired output.

Regards

Pratyush

Re: How to give common name in pivot table?

Shubham_Deshmukh — Tue, 03 Oct 2017 11:03:34 GMT

See,As my table is PIVOT one, my expressions are working on row levels right.

Now I just want to give combine name to 1st 4 exp and different name to another 4 only to show they are coming under different category.That's it.

Re: How to give common name in pivot table?

Shubham_Deshmukh — Tue, 03 Oct 2017 11:07:17 GMT

Also, I have done this thing in another situation in which I was dealing with calculated dimensions (eg: valuelist(a,b,c))

But here I have fixed dimension according to date field.That's why I am facing this issue

Re: How to give common name in pivot table?

prat1507 — Tue, 03 Oct 2017 11:07:54 GMT

Yes, I understand. But for creating different categories you need to provide different dimensions for set of expressions.

If you could provide me with a sample data and a desired output, I may be able to help you understand.

Regards
Pratyush