Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

sangeetha_changu
New Contributor

Display year wise static value across fields in Pivot table

We have year wise Contract Share% for 2018,2019. How to display the constant Contract Share % per year across the dimensions and KPIs in a pivot table 

Contract Share comes from an inline table in below format.. 

Share_DateShare_YearShare_MonthPlantCarrierContract Share (%)

 

and key has been created Share_Year&'_'&Share_Month&'_'&upper(Plant) &'_'& upper(Carrier) as %Key_ContractShare,

To Map the key in KPI table  i.e. Year([Ship Date])&'_'&Month([Ship Date])&'_'& upper(Plant) &'_'& upper(Carrier) as %Key_ContractShare,

 

Below is the screenshot which is showing wrong values for Contract Share %. Need help in correcting

contract.PNG

The actual Contract shares are below

  2019
CatalaoATRHOL50
CatalaoDICANALLI10
CatalaoDOLVITSCH10
CatalaoGEFCO5
CatalaoRODOMEU5
CatalaoSHOCK10
CatalaoTME10
1 Solution

Accepted Solutions

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

18 Replies
siddheshmane
Contributor

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

Hi,

what is your expression for Contract Share%

sangeetha_changu
New Contributor

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

sum(Contract Share%) which isn't working.

Please suggest an expression to display the static value for Contract share

 

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

You need to manipulate with Num() format?

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)
sangeetha_changu
New Contributor

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

contract1.PNG

Jesh19
Contributor II

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

From your question, I understood that values should always remain static.

You can acheive it by showing it as a dimension or an expression.

For dimension: =Num([2019]/100,'#,##0%')

For expression: Sum([2019])/100 and Under Number tab, change it to Fixed to and Enable 'Show in Percentage'

 

Thanks,

Jesh

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

@sangeetha_changu if you simply paste the image,  I strongly believe that won't help for others instead what you have handy in the expression that may helps for sure 

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)
sangeetha_changu
New Contributor

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

i was just using some trial expressions like

sum({<Year={$(vMaxYear)}>}Contract Share%)

Max({<Year={$(vMaxYear)}>}Contract Share%)

i even directly used [Contract Share %] field in expression

which is not giving me the desired results

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

Do you have some sample data set which concur the same?

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)
sangeetha_changu
New Contributor

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

Please find the attached sample qvw