6 Replies Latest reply: Nov 27, 2017 6:22 PM by Luis Madriz RSS

    list of values

    Agrim Sharma

      Hi All,

       

      i have prepared an bar chart, with Start Vs. End Topics by month, i want to get the list of the topics which are start or End if i select any month or quarter from bar chart.


      here is my attached App, please help.

       

      eg. if i select Month=Aug i should get 6 Topics in Start and 7 Topics in End but i am getting same names in start and end(See Filters)

       

       

       

      wrong.PNG

      Thanks,

        • Re: list of values
          Luis Madriz

          Hmmm, it'll be interesting to see other comments from the community.

           

          I've done it but instead of a filter pane I've used a straight table, with the project name as the dimension and a measure such as this one: Count({<Flag = {'Ending'}>} [NAME OF PROJECT (Code - Title)])

           

          I hope this helps,

           

          Cheers,

           

          Luis

          • Re: list of values
            dave liu

            these two expressions will work if you just want get the list

            =ValueList($(=Concat({<Flag = {Starting}>}Chr(39) & [NAME OF PROJECT (Code - Title)]& Chr(39),',')))

            =ValueList($(=Concat({<Flag = {Starting}>}Chr(39) & [NAME OF PROJECT (Code - Title)]& Chr(39),',')))

            微信截图_20171127173836.png

            however , you can't use it as filter any more

            • Re: list of values
              Ralf Heukäufer

              In your case you can use

               

              =if(Date=Start,[NAME OF PROJECT (Code - Title)])

               

              for your Start filter and:

               

              =if(Date=End,[NAME OF PROJECT (Code - Title)])

               

              for your end Filter

              • Re: list of values
                Luis Madriz

                Oh I think I got it,

                 

                Please try with this on the filter pane:

                =AGGR(Only({<Flag = {'Ending'}>} [NAME OF PROJECT (Code - Title)]),[NAME OF PROJECT (Code - Title)])

                 

                Untitled.png

                 

                It makes all the difference that you've sent a qvf,

                 

                Cheers,

                 

                Luis

                  • Re: list of values
                    Luis Madriz

                    I forgot:


                    PS. When applicable please mark the appropriate replies as Correct. This will help community members know which discussions have already been addressed and have a possible known solution. Please mark replies as Helpful if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as Helpful if you feel additional info is useful to others