6 Replies Latest reply: Sep 19, 2012 1:52 PM by Stefan Wühl RSS

    Parameters

      Our QlikView version is: 10.00

       

      We have just started on a QlikView (QV) project. We are migrating our SSRS 2008 reports to this platform. In SSRS we allowed users to paste in values from an Excel Spreadsheet or a Text File into a Multiline Text box. This text box was then used as a parameter/filter for the report.

       

      How do we do the same thing in QV?

        • Re: Parameters
          Stefan Wühl

          The solution is probably depending on the format of values you paste in your input box in QV and the fields / format of that fields you need to filter.

           

          There are some threads here that are suggesting solutions to similar problems, you might want to search for "input box", "filter" etc. For now, I've found this post as a start:

           

          http://community.qlik.com/message/183195#183195

           

          Regards,

          Stefan

            • Re: Parameters

              Stefan,

               

              Thanks for the reply, I understood the concept. The issue is... there will be no delimiters. Folks will be pasting it from an Excel worksheet or a text file and the values will look something like this:

               

              1306882147

              1780604413

              1982640710

              1497791230

              1740226893

              1306862834

               

              I cannot ask them to delimit the values because sometimes it might be just 2 and sometimes 200.

                • Re: Parameters
                  Stefan Wühl

                  So there may be a delimiter, a line feed.

                   

                  Check attached modified sample.

                   

                  Open the input box entry dialog by clicking in the entry field an then on the "three dots" button to open the editor. You'll see the values just copied in as lines, separated by a line break.

                   

                  I modified the button action to

                   

                  ='('&replace(vTest,chr(10),'|')&')'

                   

                  to adapt the situation to a line feed as delimiter.

                   

                  Your situtation might be a bit more complex, if your delimiter is a little different (you can also check for chr(13) CR). But maybe this guides you to some working solution.

                   

                  Regards,

                  Stefan

                    • Re: Parameters

                      Stefan,

                       

                      Call me dumb. But I could not get this to work. This is what I did:

                       

                      I created a project with 3 objects on it. A list, a button and a text box.

                       

                      • The Quarter list is called CAL_QTR. I preloaded the list from my SQL Database.
                      • The button has this code: Action = Select in Field >> Field CAL_QTR >> Search String:='('&replace(var_Quarter,',','|')&')'. I was trying with a Comma Delimiter first.
                      • In the text box, I clicked on the ellipses (...) to open the editor and typed Q4 2011 and hit the button. But it does not seem to be selecting it.

                       

                      Not sure what I could be doing wrong?

                • Re: Parameters

                  Hi bitloo,

                   

                  You can do that creating a variable and text control to modified the value who is used in report expresion.

                   

                  I hope to help you.