Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set Analysis Question

Hi,

I'm trying to get a simple set analysis expression to work.  All I want to do is show the current days average regardless of the selection criteria chosen.  I tried the formula but when I change dates the calculation changes. 

avg({1< KeyDate={'=date(today())'}>} HA1) / 100

Can anyone help me to get this working?

Thanks,

Pete

1 Solution

Accepted Solutions
Not applicable

Re: Set Analysis Question

Try this:

avg({1< KeyDate={$(=date(today()))}>} HA1) / 100

3 Replies
Not applicable

Re: Set Analysis Question

Try this:

avg({1< KeyDate={$(=date(today()))}>} HA1) / 100

MVP
MVP

Re: Set Analysis Question

Hi,

PFA, hope it helps you.

Regards,

Jagan.

Not applicable

Re: Set Analysis Question

brilliant - working now thank you both

Community Browser