13 Replies Latest reply: Jun 15, 2016 6:32 AM by Sangram Reddy RSS

    Title Stacked Bar and Period percentage

    Xandro Lisci

      Question 1

      I want to show a bar chart and by selecting a period (ReportDate) the title of the bar chart need to change with the selecting period.

       

      Example:

       

      ReportDate

      20151231

       

      20160131

       

       

      20160229

      20160331

       

      Title:

        Credit rating period: 20151231

       

      By selecting the ReportDate 20160131 the title has to change in:

       

      Credit rating period: 20160131

       

      What formula in Qlik Sense can I use? 

       

      Question 2

       

         

      How can I display the percentages of each ReportDate to 100%. Now it is showing for each period the percentage of the total of all the values for the periods 20151231, 20160131.

       

      What formula can I use in Qlik Sense?