Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

bhuprakash
New Contributor III

Data allign in Pivot

Team,

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

Active = Total - Drop/Opt-out

er.png

1 Solution

Accepted Solutions
MVP
MVP

Re: Data allign in Pivot

Like this?

Capture.JPG

14 Replies
bhuprakash
New Contributor III

Re: Data allign in Pivot

Please ignore the S. No column.

Would appreciate your quick revert.

Thanks in Advance

Re: Data allign in Pivot

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

1

2

3

4

5

];

MVP
MVP

Re: Data allign in Pivot

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

bhuprakash
New Contributor III

Re: Data allign in Pivot

Hi,

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

bhuprakash
New Contributor III

Re: Data allign in Pivot

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

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

bhuprakash
New Contributor III

Re: Data allign in Pivot

Ok Anil,

Please send me that as you are suggesting the best.

I will show it to by boss.

Re: Data allign in Pivot

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

MVP
MVP

Re: Data allign in Pivot

Like this?

Capture.JPG