2 Replies Latest reply: Nov 27, 2015 4:46 AM by Sangram Reddy RSS

    Text Expressions

      Hi All,

       

      I am creating a text box showing what fields are selected. below is what I have.

       

      *****************************************************************************************

      'Periodo Fiscal: ' & concat(distinct PeriodoFiscal,', ') & '

      Mes Fiscal: ' & Concat(distinct (PeriodoMesFiscal) & ' -  (' & (PeriodoMesDesc) & ')',', ')

      *****************************************************************************************

       

       

      So if the Fiscal Period I select 2015 and Fiscal Month selecte 1 I will receive this:

       

      *****************************************************************************************

      Fiscal Period: 2015

      Fiscal Month: 1 - (October)

      *****************************************************************************************

       

       

      But, If I select only Fiscal Period 2015, and don't select Fiscal Month, it shows all the month number and description.

      is there a way I can get for example:

       

      *****************************************************************************************

      Fiscal Period: 2015

      Fiscal Month: All

      *****************************************************************************************

       

      having "All" as no selection in month?

       

      NOTE: I am using Qlik Sense, in a server where App is created by admin. I am using the chart "Text & Image" to show information in a sheet of what date is selected.

       

      Thanks in advance

       

      Daniel