5 Replies Latest reply: Oct 27, 2017 8:51 AM by Felip Drechsler RSS

    Help displaying filtered dimensions in a chart

    Liv ma

      Hello

       

      I want to display the following chart:

      - reporting date (and some other dimension)

      - some measure

       

      the complication is that I want the measure to be calculated only for a subset of the reporting date - say for 2 reporting dates only, eg for September 2017 and August 2017

       

      therefore in the measure I use a modifier for the reporting dates

       

      the problem is that the chart still displays all reporting dates, even if for the dates other than Sep and Aug the value is 0.

       

      of course this problem is solved if I make a manual selection using a filter, but I do not want to use the filter - I want the chart only to display the measure for these 2 dates only

       

      the weirdness is that in the previous version of Qlik Sense the chart only displayed the dates for which the calculated measure was not zero and this remained like that until I modified the subtitle of this chart

       

      after modifying the subtitle, the chart started displaying all the dates

       

      thank you for your help, I hope what I wrote is understandable