3 Replies Latest reply: May 11, 2011 7:45 PM by John Witherspoon RSS

    Compare two date ranges

      I'm starting to get the basics of QV down. I've reviewed set analysis on a blog, creating date tables, and variables. I've watched the some of the designer and all of the developer training videos.

       

      Being able to create a listview and let the user choose one or more dates and having QV automatically update everything is great, but I find QV to become very frustrating if I try to move beyond that.

       

      In my data table, one column is named "Week Ending." What I'd like to do is allow users to choose and compare different weeks in the dashboard. In my trial and errors, I've been able to create charts and such using set analysis and variables. Next what I'd like to do is provide the user two lists with predefined dates that are available in the data table to choose from. The only control I see available to work with variables is the text box. Can anyone point me to a better way or a full example to use?

       

      My search for answers has been frustrated by 1) almost every google link to community.qlik.com is a 404 and 2) the qlikview help file is very insufficient and short on details.

       

      Thanks for your time.

        • Re: Compare two date ranges
          Deepak Vadithala

           

          Totally agreed with your thoughts. I had followed the same learning pattern like you

           

          Instead of using the list box you can use the slider with variable to filter the data. Visually they look very appealing and also user friendly. I would also recommend you to learn Indirect Set Analysis... which is very useful. I am attaching a pdf document.

           

          If you need further explanation, then please post the QV document with sample data and I'll quickly mock up an example for your reference.

           

          Happy learning!

           

          Cheers - DV

            • Re: Compare two date ranges

              Thanks for the pdf file. I am digesting that now. I'll post back an example setup soon. Thanks.

                • Compare two date ranges
                  John Witherspoon

                  You're probably getting 404 errors because QlikView recently completely changed their site.  All old links are now bad links.  The content has been copied across, but not with exactly the same addresses, and often not with proper formatting I've found.

                   

                  I agree that the QlikView help file is a bit unhelpful unless you know exactly what you're looking for.  "How do I do this?" isn't answered in there.  It only contains information like, "What is the right syntax and examples for this specific function."  It's more like a short reference manual than a "how to".

                   

                  I'm afraid I'm not understanding what you're after, though.  If you just want to choose and compare different weeks, have a "Week" field in your calendar table (we typically build a separate calendar table in the script when dealing with date date).  The users can then select two weeks. If a chart has week as a dimension, they can then compare those two weeks side by side.  No need for set analysis or variables for something that simple.  Of course your situation may not be that simple. 

                   

                  Hopefully when you post the example you mentioned it'll all become clear, and we can get it solved for you.