Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How to check the values of last few days in an expression

Hi ,

I am new to Qlikview . Could you please guide me on

I have a table with date range as a dimension and a column with the alarm count on that date. I dont want to create a chart where alarms will be shown for all dates . I want alarms to be shown if there are say n continous days of alarm.

eg . say n =5 , show alarm on current day when there are alarm( count>0) for last 4 days also.

1 Reply
Highlighted

Re: How to check the values of last few days in an expression

May be this?

Count({<date = {"=Count(date) > 0"}>} alarm)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)