Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
GartoJsar
Partner - Contributor III
Partner - Contributor III

Hide year in my report that does not select with the year filter

Good afternoon.
I am making a report where I show the sales positions. by the end of the month. the problem is that in my report it does not show me the dates with the month closings, but it shows all the dates of the week closings. in my table there is a field called CLOSE_MES = 1, which shows the sales by the end of the month and there is another CLOSE_SEMANA = 1, which shows the sales by the end of the week otherwise it shows 0. I put some conditions in my expression indicating that of sales by CLOSED_MES. If I select 2018 in the report shows the closes_mes of the months 2018. but the problem arises when I choose 2018 0 2019 does not hide the date that I am not choosing and I put it as the sales '-' and what should do ocualtar dates that I do not select.
I share the formula that I am applying to see if you can help me and see what the problem, as well as I share an image of the report problem.

formula:

If(Len(GetFieldSelections(AÑO,1))>0,

If(WildMatch(AÑO,2018),

SUM({$<[AÑO]={2018}, CIERRE_MES={1}>}TENENCIA),


If(WildMatch(AÑO,2019),

SUM({$<CIERRE_MES={1},[AÑO]={2019}>}TENENCIA)
,
If(WildMatch(AÑO,2020),// Anual

SUM({$<CIERRE_MES={1},[AÑO]={2020}>}TENENCIA)

))
),
SUM({$<CIERRE_MES={1},[AÑO]={2019}>}TENENCIA)

)

 

 

0 Replies