In particular I want to show 3 different tables that do not analyze or calculate anything.
I want to show
one table with EndDate >= today and EndDate <= today+30
one table with EndDate > today+30
one table with EndDate < today
so I don't want to alter the dataset for the whole document, just for the table objects.
This really feels like such a rookie question but I am stuck. Just starting out with QlikView.
First check the format of the enddate and today() are same are not
if both are same format then use the cond
otherwise use the conversion functions like date,timestamp
in ur exp instead of today()+30 use below expr
if([EndDate] >= date(today()) and [EndDate] <= date(today()+30), [EndDate], NULL() )
Hm, I get an error telling me I have invalid data near the if statement.
Before QlikView I used iNetSoft and there I could simply add any condition to any sheet object. I could right-clik on it and select condition and then say: Of all the lines of data, use only those where EndDate >= today. This was based on the object, not the whole sheet, so I could use different conditions for each table and chart.
This is what I want to do here. I'm sure it's possible and probably the solution is better than the one in iNetSoft. However, I just can't find where I can set this up.