0 Replies Latest reply: Apr 15, 2015 9:58 AM by Nandha Kumar RSS

    Cascading Filter

    Nandha Kumar

      Hi,

       

      I am facing a problem in getting this done. Can some one help me here?

       

      I have a bar chart in my dashboard. If I select one bar in the chart the rest should be faded out (pls refer the attached image green selected and rest grayed out).

       

      In this https://community.qlik.com/thread/122191#550067 link they asked to use brushing concept. But I am not able to use this as I am using set analysis.

       

      I am using the below expression for my chart. This will help me to bring data when ever I click the appropriate button. But I am not able to use brushing concept ( let me know where to put this {1}) in my expression.

       

      =if(Period=1, Count({$<d_date= {">=$(=date(interval(DAte(now()) - 7,'D'),'MM/DD/YYYY'))<=$(=date(now(),'MM/DD/YYYY'))"}>}minerva_order_id),
      if(Period = 2,Count({$<d_date = {">=$(=date(interval(DAte(now()) - 30,'D'),'MM/DD/YYYY'))<=$(=date(now(),'MM/DD/YYYY'))"}>}

      minerva_order_id),

      if(Period = 4,Count({$<d_date = {">=$(=date(interval(DAte(now()) - 28,'D'),'MM/DD/YYYY'))<=$(=date(now(),'MM/DD/YYYY'))"}>}

      minerva_order_id),

      if(Period = 3,Count({$<d_date = {">=$(=date(interval(DAte(now()) - 91,'D'),'MM/DD/YYYY'))<=$(=date(now(),'MM/DD/YYYY'))"}>}

      minerva_order_id),

      if(Period = 5,Count({$<d_date = {">=$(=date(interval(DAte(now()) - 365,'D'),'MM/DD/YYYY'))<=$(=date(now(),'MM/DD/YYYY'))"}>}

      minerva_order_id),

      Count({$<d_date= {">=$(=date(interval(date(vStartdate) - 0,'D'),'MM/DD/YYYY'))<=$(=date(vEnddate,'MM/DD/YYYY'))"}>}

      minerva_order_id))))))

       

       

      Using this in the expression attribute 

      =if(overriden_reason=overriden_reason, color(FieldIndex('overriden_reason',overriden_reason)), RGB(230,230,230))

       

      Regards,

      Nandha