Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME 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?