topic Re: name in QlikView

name

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

In pivot table i have three dimaensions

Department

section and

branch

and i have 4 expressions

now the i have 3 columns for dimension if expanded else there will be one column ....

Now i want to know how do i give a single name as a header to this three columns ? as a Description

PLease find the attached sample , Basiaclly i want to hide the culumn names Department , Section and Bransh , and have a single header for this as Description .

Thnaks in advance

Re: name

devarasu07 — Tue, 21 Mar 2017 06:46:38 GMT

Hi,

Can you share your Mock Data with sample app. Tks

Re: name

Anil_Babu_Samineni — Tue, 21 Mar 2017 06:46:48 GMT

Create calculated dimension ValueList('Nameasyourwish') and then change column to row on the top be help of Mouse. In fact, This feature works only for Pivot not straight object

Re: name

smilingjohn — Tue, 21 Mar 2017 07:01:12 GMT

Hi Anil

Thanks for your reply .

I need it for Pivot table only , Anile can you please give me a sample f this , it will be more helpfull for me

Re: name

devarasu07 — Tue, 21 Mar 2017 07:15:26 GMT

Hi,

PFA, tks

Cal.dim as below expression

=ValueList('Sample')

Re: name

smilingjohn — Tue, 21 Mar 2017 07:22:15 GMT

Hi Devarasu ,

Thanks for the effort you took to explain me ... look i have attached qvw sample app.

In your above expamle brans, section and Department should be hidden , and the whole three column whould have single header name as Description (branch,Department and section should be hidden)...Please find the qvw attached ....
i

Re: name

devarasu07 — Tue, 21 Mar 2017 07:27:53 GMT

Hi,

can you share your expected output screen image. tks

Re: name

smilingjohn — Tue, 21 Mar 2017 07:31:38 GMT

Hi Devarasu,

Please find the screenshot , look this is how i want , i hope iam clear now .

Here they are hiding the column name (Dimensions) and giving one name for the dimensions as Description.

Thanks

Re: name

devarasu07 — Tue, 21 Mar 2017 07:35:58 GMT

Hi,

Ok, we have create hierarchy/drill down method for your case. tks

Hierarchy function in Qlikview – QlikviewDiary

Hierarchy function easy and Efficient with example---

Hierarchy in QlikView

hope this helps you

Regards,

Deva

Re: name

stabben23 — Tue, 21 Mar 2017 07:49:44 GMT

Hi John,

maybe this is Close enough:

Re: name

smilingjohn — Tue, 21 Mar 2017 08:22:15 GMT

Hi Staffan ,

How did you do this , Great this is what i wanted

Re: name

stabben23 — Tue, 21 Mar 2017 08:29:30 GMT

This is the trick: