Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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?