topic Re: column change in QlikView

column change

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

Hi,anyone is there??

i need a help.

i have created a bucket...in front end it shows the total value at the column no. 1..i used pivot table...i have to change the column of the total value to whrevr i want..is there any option..can i change ths in script.pls hlp..me

Re: column change

Chanty4u — Mon, 26 Dec 2016 07:08:16 GMT

u want to change label name or how it is?

Re: column change

Anonymous — Mon, 26 Dec 2016 07:12:35 GMT

No,I need to change whole column...to the next column..do u get dt..i am having grand total..bt it appears in first column....i have to change the column ..whrever i wnt

Re: column change

Chanty4u — Mon, 26 Dec 2016 07:21:51 GMT

Am not sure

You just need to drag columns, by selecting column header for dimensions only.

You cannot drag expression column to be as a first one.

orelse

Go to expression tab and play with promote and demote feature.

Re: column change

Anonymous — Mon, 26 Dec 2016 07:26:07 GMT

i can't drag the columns...also thts not a dimension and measures..so i can't use promote,demote function too..can i do this through the script..is there any option

Re: column change

Anonymous — Mon, 26 Dec 2016 07:28:31 GMT

i need my output like ths nly,,bt the column of total value shows in column no.1..how can i change

Re: column change

Anil_Babu_Samineni — Mon, 26 Dec 2016 07:29:56 GMT

When you are talking related script, you may show few screen shots with expected output on Pivot Table. Your first posting related to just column moving - Already Chanty gave same reply to you. Can you elaberate more

Re: column change

Anonymous — Mon, 26 Dec 2016 07:34:06 GMT

See,this is my problem..i can't change the column of total value..i can't drag..i cant promote demote..i need this total value at the column no.3

Re: column change

Anonymous — Mon, 26 Dec 2016 07:54:15 GMT

Hi,

I would suggest, create expression for each category as well as total.

E.g. Create expression for below

0-7 days
8-15 days
....
Total
>7

Re: column change

varshavig12 — Tue, 27 Dec 2016 06:04:16 GMT

I guess we can only set the Total column as the first column( i.e Top) or as the last column (i.e bottom ).

--> In presentation tab

As suggested by Payal, you need to add Total in your bucket expression and then sort accordingly.

Re: column change

Anonymous — Wed, 28 Dec 2016 07:08:05 GMT

Thanks payal..your post is helpful.

Re: column change

vinod_nallapaneni — Wed, 28 Dec 2016 08:23:54 GMT

Hi,

R u using multiple expressions in your pivot? If yes,

Use column() function

Example:

Expression 1

Expression 2

Total= Column(1)+

Column(2)