3 Replies Latest reply: May 17, 2018 8:53 AM by Sunny Talwar RSS

    Pre-Selecting a dimension & making the chart dynamic

    vishal raina

      I have the following requirement : Urgent

       

      I have the attached chart "Chart_Overall" in Qliksense created from dimensions Week(1,2,3,4) and Item (Cap,Helmet,Bottle, Random) with measure sales.

       

      What is need is that when the dashboard is opened the chart should be pre selected on Item -"Cap". And i should also be able to change selections on the chart using Item as a filter as well.

       

      Till now i'm able to make the pre selections in the chart but somehow the chart is not changing dynamically after selections made from  Item filter.

       

      In the chart I'm using the dimensions as Week, Item and

      measure as

      =if(getselectedcount(Item) = 0,Sum({$<Item= {"= Item like 'Cap*'"}>}Sales),

      Sum({$<Item= {'$(=GetFieldSelections(Item))'}>}Sales))

       

      Any  help would be appreciated.