5 Replies Latest reply: Apr 23, 2018 6:24 AM by Toni Kautto RSS

    need help with linechart

    satish qlik

      Hi everyone,

       

       

      I have a requirement on line chart in Qlikview/Qliksense, Please find the below attachment

       

       

      >by defalut it has to show Sum(Vol)....(if no selections made)

      >If I select any brand it has to show 2lines

      one line with Sum(act) and another line with Sum(fore)

       

      I have created two saparate line charts with Sum(Vol) and another line chart with Valuelist.

       

      But I want to show both requirements in single line chart(to put both expressions in single line chart) based on these conditions.

       

       

      I have tried with Getselections but not working.

      Dim1: Year

      Dim2: If(GetSelectedCount(Brand)=0,brand,ValueList('_Act', '_Fore'))

      If(GetSelectedCount(Brand)=0, Sum(Vol), Pick(Match(ValueList('_Act', '_Fore'), '_Act','_Fore'), Sum(act),Sum(fore)) .

       

       

      Any suggestions will be appreciated.

       

       

      Please help me out in this.

        • Re: need help
          Petter Skjolden

          Please provide a descriptive text for the title of your question. Community guidelines will explain why.

          • Re: need help
            Sasidhar Parupudi

            What is not working properly?

            how are act and fore related to brand?

            • Re: need help with linechart
              Toni Kautto

              My interpretation of your requirement is that you are looking for two different views on your data. One view shows the volume, and the other shows actual vs forecast sales. What I don't understand is why you would want to force theses two things in to the same chart? I think you are over complicating this, my advise keep things simple and manageable.

               

              My main suggestion is that you think of the workflow you want to create in the Qlik Sense app. Essentially, don't force the business user into a guided reporting model, where you dictate what the user should look at. Allow more flexibility around the discovery of your data.

               

              There are two very simple options, which might work in this case. 

              1. Create two chart in the same sheet. One shows volume, and one shows sales. This allows your user two look at both things at the same time. If you struggle with fitting the charts into the same sheet, take a look at April 2018 release and the new option to resize layout grid.
              2. Create different sheets. User can navigate to for example a sales sheet and look at more details related to actual vs forecast sales. By leading the app with a overview dashboard, and providing more details through additional sheets you give the user flexibility to navigate the data in many ways.

               

              Regarding your attempted solution. My general advise is that you avoid using calculated dimensions, as this will easily lead you to unexpected results, or in worst case misleading results. Commonly when you want a selective filtering the expression can have set expressions or if statements to control the aggregated data set.

              If you are not familiar with synthetic dimensions, I would advise on not using Valuelist() in you charts. This function will not provide you the pairing of values that you expect.

                • Re: need help with linechart
                  satish qlik

                  Can you provide sample solution and I have attached sample data in the above.

                   

                  I achieved the same thing in Qlikview but I want in Qliksense.

                   

                  please help on this.

                    • Re: need help with linechart
                      Toni Kautto

                      You are referring to two charts. Both have very simple measures, I am not sure why you can not set it up yourself.

                       

                      You example has a synthetic complexity that does n t make any sense at all to me. Dimensions and measures essentially work the same way in QlikView and Qlik Sense, so if you have something that works in QlikView just apply the same in Qlik Sense?