2 Replies Latest reply: May 2, 2015 1:37 AM by Pradeep Kumar Pandey RSS

    Column value mismatch

    Pradeep Kumar Pandey

      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
          Massimo Grossi

          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

            • Re: Column value mismatch
              Pradeep Kumar Pandey

              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