Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
sangeetha_changu
New Contributor

Re: Display year wise static value across fields in Pivot table

 
Highlighted
sangeetha_changu
New Contributor

Re: Display year wise static value across fields in Pivot table

 
Highlighted
Jesh19
Contributor II

Re: Display year wise static value across fields in Pivot table

Using your sample2.xls, I got the below solution.

 

CS.PNG

Max(Contract Share %) worked for me.

Thanks,

Jesh

sangeetha_changu
New Contributor

Re: Display year wise static value across fields in Pivot table

sorry i already tried it but doesn't work. Please check the three attachments and sample QV file for reference and suggest the needful

Highlighted

Re: Display year wise static value across fields in Pivot table

Try this?

Min(TOTAL <Carrier> [Contract Share (%)])

If this is not working, can you explain one row how the value calculated?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
sangeetha_changu
New Contributor

Re: Display year wise static value across fields in Pivot table

Hi Anil

The expression you suggested is working for few carriers --- Min(TOTAL <Carrier> [Contract Share (%)])

But for some of the carriers it is not working

To explain more about the rows, The Data from Sample file is the KPI data we get from Database and Sample2 is the inline data that we created for Contract share for each year based on plant and carrier. 

We are trying to link Contract Share data to KPI data through key i.e. %Key_ContractShare. Let me know if you need more details. We are looking for quick help. Thanks in advance

Highlighted
sangeetha_changu
New Contributor

Re: Display year wise static value across fields in Pivot table

Hi Anil

This expression worked for us --- Min(TOTAL <Carrier> [Contract Share (%)])

But the 'Total' (Total per plant) in the Pivot table is showing the minimum value. As per the excel statis data for Contract Share the Total should always be 100% .

Could you please suggest on Total as well. Thanks in advance.

 

 

 

Highlighted

Re: Display year wise static value across fields in Pivot table

Check this?

Sum(Aggr(Min(TOTAL <Carrier> [Contract Share (%)]), <Dim1>, <Dim2>, ..))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Highlighted
sangeetha_changu
New Contributor

Re: Display year wise static value across fields in Pivot table

This worked.

Thanks a lot Anil