Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

What is wrong in the expression ?


I shared a sample data in attachments 

As example data
in Overview pivot have Large Claim
and High claimant
in year 2019 (report Year) we have Large Claim = 777,594 it is true because 777,594 > 700,000(Large Claim)
but High Claimant it is wrong because in 2019 we have 777,594 and in 2018(prior year) we have 1,633,221 but in High Claimant Overview pivot we have 11,483 it is wrong must show 1,633,221 on displays.

Please help.

1 Reply

Re: What is wrong in the expression ?

You want 1,633,221 for 2017, right? because I see 11,483 as Prior Year when 2018 is selected