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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

query

I have one doubt if i create a chart between the month and expression or GLcode and expression

=if(Particulars='Administration expense',

//

//+

num(fabs(sum({<[Fiscal Year_GJAHR] = {'$(vMaxYear1)'},Year=, P_RYEAR=,Companyode={'1500'} >}AmountInLC_Actual_PNL)

/10000000),'#,##0.00' )

)//)

it will give 5.65 but if  export the same in excel it will give 6.62 .Any body have any idea what is the reason behind it

1 Reply
Not applicable
Author

=if(Particulars='Administration expense',

num(fabs(sum({<[Fiscal Year_GJAHR] = {'$(vMaxYear1)'},Year=, P_RYEAR=,Companyode={'1500'} >}AmountInLC_Actual_PNL)

/10000000),'#,##0.00' )

)