Hide Formula when selecting in filter panes

[UserID2626]

Hi,

I want to hide a formula in top of sheet when selecting in filter pane.

Given date in filter pane(formula:date(Business_date,'D-MMM-YYYY') and given a label 'Date' . When selecting a date from filter  getting a formula in top, is there is way to hide the formula from end users.

[Anil_Babu_Samineni]

This is not yet resolved with Qliksense Product.

Work around : Use that in the script as field and maintain that field in the filter.

[StarinieriG]

Hi,

create a master dimension, then use it and the formula will disappear

[AdiPai]

Rename it and provide a description , post this - you should only get the description and not the formula 

[SukumarBera]

Please can you give a try with below expression.

=AGGR(Date(Business_date,'D-MMM-YYYY'), Business_date)

[UserID2626]

Hi SukumarBera,

This hides formula from end user, but this formula is not allowing for Multiple selection of date

[SukumarBera]

Hi,

I think what you mean to say is that, when you select one/more values, the alternate values get disappeared from the filter pane. 

Earlier expression: =aggr(Date(Business_Date,'DD-MMM-YYYY'),Business_Date)

To fix we have to use AGGR with set analysis.

New Propsed expression: =aggr(Only({1}Date(Business_Date,'DD-MMM-YYYY')),Business_Date)

See below snap from my sample App.

[UserID2626 · Accepted solution]

Thanks  Anil_Babu_Samineni

Thanks StarinieriG

Thanks SukumarBera 

Three methods also working fine, but i have option to accept as solution only one.

[SukumarBera]

Nice to hear that your query got resolved.

Please mark this thread as " resolved".