Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

pkpandey
New Contributor II

Column value mismatch

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,

2 Replies
MVP
MVP

Re: Column value mismatch

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

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

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

1.png

pkpandey
New Contributor II

Re: Column value mismatch

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

© 1993-2014 QlikTech International AB |

Copyright & Trademarks | Privacy | Terms of Use | Software EULA

Community Browser