5 Replies Latest reply: Mar 6, 2018 4:43 PM by David Forest RSS

    need help

    satish qlik

      Hi,

       

      I need help on ignoring selections.

       

      I have pie chart

      with

      dims-->Zone,counrty

      and

      measure--->Sum(distinct {<Year={"$(=$(_vCurrentYear))"},Brand=>}volume)

       

       

      My requirement is : If I select any country in pie chart, it shouldn't be effect in other chart(bar chart)

       

      In Bar chart

      dim--->Country&'-'&Brand

      and

       

       

      Measure1--->

       

      (((Sum({1<Measure=,[KPI Type]={"Volume"},KPI={"B F C"},

      BF_Year={"$(=$(_vBFCurrentYear))"}>}BF_Volume))/1000)

      /

      ((Sum({1<Measure=,[KPI Type]={"Volume"},KPI={"B F C"},

      BF_Year={"$(=$(_vBFLastYear))"}>}BF_Volume))/1000)

      -1)

      *100

       

      Measure2--->

      (Sum({1<Measure=,[KPI Type]={"Volume"},KPI={"B F C"},

      BF_Year={"$(=$(_vBFCurrentYear))"},Country>}BF_Volume))/1000

       

       

      I tried with Country= under the set expression but not working

      any suggestions??? 

        • Re: need help
          Teis Thrane Wamsler

          Hi satish

           

          try replace the Identifier "{1<" to "{$<" in the expression and add Country= i set analysis.

           

          /Teis

          • Re: need help
            David Forest

            You shouldn't need to use 1 unless you want all other dimensions excluded.

            To exclude a dimension you would add Country= with the qualifier set to $ instead of 1

            Any of the variables,$(_vBFLastYear),$(_vBFCurrentYear) used would also need that exclusion added

            You may need to exclude other dimensions as well based on your data; it may look like Country is changing the values, but it may be some other dimension like Zone.

              • Re: need help
                satish qlik

                Hey Thank you for suggestion

                 

                these are the variables which I have created

                $(_vBFCurrentYear):

                Only([Forecast Start Year])-1

                 

                $(_vBFLastYear):

                Num(Only([Forecast Start Year])-2,'####')

                 

                also I tried with with counry=, zone= in the set expression but still no use.

                 

                any suggestions on my expression ??

                  • Re: need help
                    David Forest

                    Would need sample data to help further; including all the data tables involved. Are you copy and pasting from your app the exact code?

                    Also noticed upon looking again, do you really want a Sum of distinct volumes in pie?

                    Is there a volume and BF_Volume?

                    Why does _vBFLastYear have a num() and _vCurrentYear not?

                    Set analysis is very finicky, be sure every piece/variable evaluates as expected by placing values in a text object. Poorly formed Set Analysis may syntactically check but yield an empty set or have no effect if the expression evaluates to null