Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
dandaanilreddy
Contributor II

Date Expression in qliksense

Hello Qlik Developers

I have created an expression as ='"'&date(today()-4)&'"' its displaying the date in Qlikview, but when i wrote the same expression in qliksense its not displaying the date. i am using this expression in pivot table. Can someone help me how to achieve the date in pivot table?

Thanks,

Anil

3 Replies
rittermd
Honored Contributor

Re: Date Expression in qliksense

I just plugged your expression into one of my QS apps and it worked fine.  See attached.  Let me know what you were trying to do differently.Capture.PNG

rittermd
Honored Contributor

Re: Date Expression in qliksense

It also worked in a Pivot Table for me.

dandaanilreddy
Contributor II

Re: Date Expression in qliksense

Hi Mark

Thanks for your reply. I have created a field like

Count(If(Date(Date((Kit_received)),'MM/DD/YY')='$(vMax4Day)',Kit_ID)) AS [$(vMax4Day)]

The field is displayed as [='"'&date(today()-7)&'"']

When i took this field in pivot table in qlik sense its not displaying as date. Please look into the below image.image.PNG

Thanks

Anil

Community Browser