topic Re: Data allign in Pivot in QlikView

Data allign in Pivot

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

Team,

Please check the below Dashboard. I want Active counts row as given in dashboard.

Active = Total - Drop/Opt-out

Re: Data allign in Pivot

bhuprakash — Fri, 12 Jan 2018 11:09:00 GMT

Please ignore the S. No column.

Would appreciate your quick revert.

Thanks in Advance

Re: Data allign in Pivot

Anil_Babu_Samineni — Fri, 12 Jan 2018 11:12:08 GMT

This can be achievable? Not sure how to reload the application. But, You need one more island table like. Can you paste below table into script and load then share again

Load * Inline

Dim

];

Re: Data allign in Pivot

tresB — Fri, 12 Jan 2018 11:22:16 GMT

Do you want Active to be calculated? Or, the positioning of the row is what you are struggling with?

Re: Data allign in Pivot

bhuprakash — Fri, 12 Jan 2018 11:29:54 GMT

Hi,

I have done the calculation but facing problem in alignment as required.

Re: Data allign in Pivot

bhuprakash — Fri, 12 Jan 2018 11:31:34 GMT

Dear Anil,

No issue if Serial No is not coming.

Only issue in aligning the Active after or before the Total.

Re: Data allign in Pivot

Anil_Babu_Samineni — Fri, 12 Jan 2018 11:36:06 GMT

I thought, I've misread the thread. But, My assumption is make sense. And you used Active as Dimension as already exist. But, If i want to build that i will make without dimension and i will build using Static names for Pick(Dim,'...).. Because, In pivot table We have only top options not for border options. If you can make what i suggest i will surely send the same with you

Re: Data allign in Pivot

bhuprakash — Fri, 12 Jan 2018 11:40:11 GMT

Ok Anil,

Please send me that as you are suggesting the best.

I will show it to by boss.

Re: Data allign in Pivot

Anil_Babu_Samineni — Fri, 12 Jan 2018 11:42:51 GMT

Try to reload() what i suggest and then i will work out..!

Re: Data allign in Pivot

tresB — Fri, 12 Jan 2018 11:43:50 GMT

Like this?

Re: Data allign in Pivot

bhuprakash — Fri, 12 Jan 2018 11:57:35 GMT

yes Tresesco,

Exactly I want this. Thanks a lot for your quick support.

Also thank u Anil for your quick help.

Re: Data allign in Pivot

bhuprakash — Fri, 12 Jan 2018 11:58:21 GMT

But please check =if(dummy=1) like code is showing in column.

Please check this

Re: Data allign in Pivot

tresB — Fri, 12 Jan 2018 12:03:43 GMT

You can change the label like:

Re: Data allign in Pivot

Anil_Babu_Samineni — Fri, 12 Jan 2018 12:43:40 GMT

What if Dummy Field is not available? I meant, If we don't have field with some sequential order. Then, How we can develop?

Just to know - If you have time please reply.

Re: Data allign in Pivot

tresB — Fri, 12 Jan 2018 12:53:17 GMT

Dummy is not required to be sequential. It can be anything as an island. And if you don't want a new field in the script, you might have to use synthetic dimension; using valuelist()/valueloop(), which I don't prefer in such cases.