topic Re: Column value mismatch in Integration, Extension & APIs

Column value mismatch

pkpandey — Fri, 01 May 2015 16:40:55 GMT

Dear All

I have a pivot table and it is showing correct data in cheque no and cheque dt while any code is selected but when there is not selection it is showing wrong cheque no and cheque dt. It should show Code wise maximum cheque no and cheque dt for the selected period. For Example the table should show the following but in scheenshot it is showing wrong.

A01 - Cheque No - 1003 and Cheque Dt - 07/12/2014,

A02 - Cheque No - 1103 and Cheque Dt - 06/12/2014,

A03 - Cheque No - 2102 and Cheque Dt - 04/12/2014,

Re: Column value mismatch

maxgro — Fri, 01 May 2015 17:00:09 GMT

If i understand, Cheque No and Dt should be 2 expression, not dimension

Max({<ChekDt ={'>=$(vFromDt)<=$(vToDt)'}>} ChekNo)

Max({<ChekDt ={'>=$(vFromDt)<=$(vToDt)'}>} ChekDt)

Re: Column value mismatch

pkpandey — Sat, 02 May 2015 05:37:10 GMT

On Fri, 01 May 2015 22:30:53 +0530 Massimo Grossi wrote

Many thanks Massimo for your quick reply and it is working with the application I have sent to you. But in my original application it is not working properly. Should I send you my Original Application. It is very urgent.

Best Regards

P.K.Pandey

Column value mismatch

reply from Massimo Grossi in Qlik Sense - Integration, Extensions and APIs - View the full discussion

If i understand, Cheque No and Dt should be 2 expression, not dimensionMax({} ChekNo)Max({} ChekDt) https://community.qlik.com/servlet/JiveServlet/downloadImage/2-766160-85512/1.png

Reply to this message by replying to this email, or go to the message on Qlik Community

Start a new discussion in Qlik Sense - Integration, Extensions and APIs by email or at Qlik Community

Following Column value mismatch in these streams:

Inbox