Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
SatyaPaleti
Creator III
Creator III

How to get records in table greater than specific date with out using expression

Hi Friends,

I need your help in the below requirement

How to get records in table greater than specific date with out using expression. I will explain in detail I am using a Table it have to show greater than specific date. 

I have taken Date as a dimension and in the Measure I have used following formula 

count({<[Date]= {">01/01/2019"}>}1)

SatyaPaleti_0-1612286964102.png

But User don't want to see Test (Measure). So we need to setup expression in Dimension only. 

Can some one please give some suggestion or any help on this

 

Thanks,

Satya

 

Labels (1)
1 Reply
sonkumamon
Creator
Creator

Hi,

You can write in the dimension:

If(Date>'01/01/2019',Date)