Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
guitartrova
Contributor III

Calculate difference two columns pivoting table only 1 dimension qlik sense

Hi Experts! I need your help to calculate difference or variation of two columns pivoting table only 1 dimension qlik sense.

I need to add another column with the official team variation and backup.

 

Dimension Row

Company

Column

equipment

Measure

Sum(Sales)

 

qlik sense ask.png

1 Reply
Partner
Partner

Re: Calculate difference two columns pivoting table only 1 dimension qlik sense

hi,

did you try : 

column(1) -column(2) or sum(measure1)-sum(measure2)

bye