Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
dineshm030
Creator III
Creator III

Values are mismatching in Pivot Table

Hi All,

When I select March Month in List Box, the value is coming perfect for March month whereas select Apr month it is showing as wrong

Below is screenshot for your reference.

I want to see the value (130618) for match while selecting any months. Kindly please help me.

The correct value is 130618.

Expression:

(sum({$<Version_Desc = {'Adjustment','Actual'},SalesType_Key={'1'},SalesPeriod = {1},Month={'*'},Calendar_Month = {'<=$(=max(Calendar_Month))'},Day_Number_In_Month = {'<=$(=max(Day_Number_In_Month))'},Day_of_Week=>}Sales_Value))/1000

1 Reply
vishsaggi
Champion III
Champion III

Can you share a sample file to look into?