Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'
)
Hi Daniel,
This is an other way to achieve the same.
=If(GetSelectedCount(<Field>))>0,getcurrentselections(<Field>),'ALL')Text Expressions