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: 
Not applicable

Problem in calculation

Dear All

I have a problem i cant understand why this happen require expert advise i have pivot table with no any selection the table give me the wrong figures of two columns like this

NUMNo. Of DisbursementLast Disbursal DateLast Disbursal AmountDisbursement AmountNo. Of WithdrawalLast Withdrawal DateLast Withdrawal AmountWithdrawal Amount
789453919-01-2015034200618-12-2014032000
4521251118-12-2014038400518-12-2015038000
5487121118-12-2014038400918-12-2016038000

and when i select the list box num it give the the right figure

NUMNo. Of DisbursementLast Disbursal DateLast Disbursal AmountDisbursement AmountNo. Of WithdrawalLast Withdrawal DateLast Withdrawal AmountWithdrawal Amount
1245781118-12-20144500384001119-12-2014450038000


the num is mu dimenshion and remaining is my expressions..

Prompt response is highly appreciated

3 Replies
MK_QSL
MVP
MVP

124578? Where it is?

Provide proper data to work..

Not applicable
Author

this is dummy data just for understanding and i want the amount of last disbursal date.

MK_QSL
MVP
MVP

Can you provide the result you are looking for based on the data provided?