Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Multiple expression for each dimension value in straight table

Hello,

I need to represent below data in a straight table.

The tittle column would be be a inline/excel load.

In the below scenario each tittle value has a different logic for calculation.

Currently i create three expression's to display Çurrent Year'value for corresponding dimension value.

How can 'Previous Year' and 'Difference ' be represented?

 

 

TittleCurrent YearPrevious YearDifference
Gross margin / Tel .Sales %500400100
Gross margin / Concession Sales %600500100
Gross margin / Main Stores Sales %900300600
1 Reply
Highlighted
Specialist
Specialist

Re: Multiple expression for each dimension value in straight table

Hi,

I would do a pick/match like below/attached toy application, but sounds like you already have something for Current Year, so what does that look like?

20200517_1.png

Cheers,

Chris.