topic Re: Pivot Table data Issue in QlikView

Pivot Table data Issue

Anonymous — Mon, 22 Jan 2018 12:30:43 GMT

Hi I am having the Pivot table with the Dimension of BU and TEAM

they Have Excluded some teams which are present in the 2017 and that should not present in the 2018

Bu and Team are Different table and doesn't have any year wise filtration.

Sample Table:

I want to Remove the Highlighted Red Column in the 2018 Report but it is need to Present in the 2017 Report

Kindly help me out

I having the common Filter as Year from the Dimension time

if i select 2017 highlighted red column should display

if i select 2018 highlighted red column should not display

stalwar1‌marcowedel‌devarasu07‌kaushik.solanki‌marcus_sommer‌luismadriz‌

Re: Pivot Table data Issue

Anil_Babu_Samineni — Mon, 22 Jan 2018 13:31:20 GMT

If Measure2 have values, you cannot, Either you could use If condition for each

Re: Pivot Table data Issue

Anonymous — Mon, 22 Jan 2018 13:37:20 GMT

Hi Anil,

Kindly help me out with this requirment

Re: Pivot Table data Issue

Anil_Babu_Samineni — Mon, 22 Jan 2018 13:38:51 GMT

May be post sample application to test

Re: Pivot Table data Issue

Anonymous — Mon, 22 Jan 2018 13:41:42 GMT

Hi Anil it is very difficult to create the sample app same as like that becoz it is very big application

Re: Pivot Table data Issue

Anonymous — Mon, 22 Jan 2018 13:42:13 GMT

I need to hide only that highlighted team in the 2018

Re: Pivot Table data Issue

Anil_Babu_Samineni — Mon, 22 Jan 2018 13:43:51 GMT

Can you do Suppress When value is Null From Dimension level?

Re: Pivot Table data Issue

Anonymous — Mon, 22 Jan 2018 13:52:37 GMT

If I suppress based on dimension ,it is not displaying the value in the 2017

But I don't need that in the 2018 but I need to present In 2017

Is there any possible way to write any condition for it

Re: Pivot Table data Issue

YoussefBelloum — Mon, 22 Jan 2018 13:56:39 GMT

Hi,

Try this on the dimension:

=if(GetFieldSelections(Year)=2017, if( isnull(BU), BU, BU))

make sure to deselect "suppress null values" on the presentation tab

Re: Pivot Table data Issue

Anil_Babu_Samineni — Mon, 22 Jan 2018 14:08:17 GMT

This is possible, Can you make sample?

Re: Pivot Table data Issue

Anonymous — Mon, 22 Jan 2018 14:54:00 GMT

hi anil , sample means what you are asking bro, my query is need to eliminate the team only for 2018 and need to present in 2017

Re: Pivot Table data Issue

Anonymous — Mon, 22 Jan 2018 14:54:37 GMT

where should i used this dimension , i have used it in calculated dimension but the result is same

Re: Pivot Table data Issue

YoussefBelloum — Mon, 22 Jan 2018 15:00:47 GMT

Yes it should be used as a calculated dimension.

Like Anil said, if you add sample app, something that replicates what you have on the original one, we can help you more

Re: Pivot Table data Issue

Anonymous — Mon, 22 Jan 2018 15:46:26 GMT

i dont know how can i provide the sample data for this requirment,

please help me out how can i make it as sample

because all the data are loaded from the data base and doing the binary load

how can i provide the sample data in this

Re: Pivot Table data Issue

Anonymous — Mon, 22 Jan 2018 16:21:19 GMT

kindly let me know is there any condition is dr to apply

if there is no team mapped to bu i should not display the team

please help me out