Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
UserID2626
Creator II
Creator II

Hide Formula when selecting in filter panes

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.

clipboard_image_0.png

1 Solution

Accepted Solutions
UserID2626
Creator II
Creator II
Author

Thanks  

StarinieriG

Thanks SukumarBera 

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

 

 

View solution in original post

8 Replies
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.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
StarinieriG
Partner
Partner

Hi,

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

AdiPai
Creator II
Creator II

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

SukumarBera
Contributor III
Contributor III

Please can you give a try with below expression.

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

UserID2626
Creator II
Creator II
Author

Hi SukumarBera,

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

SukumarBera
Contributor III
Contributor III

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
Creator II
Creator II
Author

Thanks  

StarinieriG

Thanks SukumarBera 

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

 

 

View solution in original post

SukumarBera
Contributor III
Contributor III

Nice to hear that your query got resolved.

Please mark this thread as " resolved".