Text Expressions

[#1]

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

[tamilarasu]

Hi Dainel,

Try like,

=If(GetSelectedCount(Your List Box Field)>0, Your Expression , 'ALL' )

Your expression should be,

=If(GetSelectedCount(Your List Box Field))>0,

         ' & Concat(distinct (PeriodoMesFiscal) & ' -  (' & (PeriodoMesDesc) & ')',', '),

           'ALL'

)

[reddy-s]

Hi Daniel,

This is an other way to achieve the same.

=If(GetSelectedCount(<Field>))>0,getcurrentselections(<Field>),'ALL')Text Expressions