Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
sangeetha_changu
Contributor
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
Anil_Babu_Samineni

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
Creator
Creator

Hi,

what is your expression for Contract Share%

sangeetha_changu
Contributor
Contributor
Author

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

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

 

Anil_Babu_Samineni

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
Contributor
Contributor
Author

contract1.PNG

Jesh19
Creator II
Creator II

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

Anil_Babu_Samineni

@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
Contributor
Contributor
Author

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

Anil_Babu_Samineni

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
Contributor
Contributor
Author

Please find the attached sample qvw