Qlik Community

Qlik Sense App Development

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

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
Highlighted
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