Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Calculated column pivot not showing on each row

Dear forum,

I got a problem in my pivot, where i got a calculated column. 

I am using the following expression: 'If(Match([Store ID],4), Sum(TOTAL {<[Store ID] = {1,2}>}$(vYTD)))', where store ID is a column and vYTD my measure.

My problem is that the calculated field only calculates the value to the no dimension field, how can I change my expression so it shows on each row for every dimension the calculated field? 

 

Pivot.JPG

 Many thanks in advance

 
 
  •  
Labels (1)
0 Replies