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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Date related in straight table

Hi Qlickers,

In my data one field name [Start Date] containing the 2012,2013,2014 years data.

My requirement is I'm using the straight table,

In the straight table I want to show only 2014 data i.e from 01/01/2014 to till...

I want to write the condition in only chart level not for the script level..

Thanks in Advance......
Gysbert Wassenaar Henric Cronström

1 Reply
MK_QSL
MVP
MVP

Dimension

Whatever you want...

Expression - Something like below

SUM({<Date = {">=$(=YearStart(Today()))<=$(=Today())"}>}Sales)