Date start to end Where statement.

[#1]

Hello,

I'm a intern at a ERP Software company assigned to write reports with Qlikview.

Now i have a table with Datecreated and Datedone, I want to create a where statement that selects records that have been open for longer

then 7 days.

I already looked at the other solutions at this forum but i din't always fully understand them or they din't fit my needs.

Thank you and kind regards Luuk.

[#2 · Accepted solution]

Hello,

I can't guess where you want to use your "Where-Statement". I raw idea is to create a chart with a calculated dimension from YourField.

=if (Datedone- Datecreated >7, YourField, 'Others')

Chart Properties --> Dimensions --> Button "Add calc dim". For exam start with a straight table, the calc dim as above and a simple expression.

Regards, Roland

[#3]

Hello Roland,

Thank you for your quick response. Sorry for not specifying my problem in more detail. I wanted to make a straight table next to a chart displaying the current record selected and highlighting those red that had been open for more then 7 days. Your solution seems to work perfect.

Thank you,

Regards Luuk.