Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
CostinelRO
Contributor II
Contributor II

BOXPLOT limit days

Hello,

I want to represent the last 6 days of data as a boxplot but I'm having dificulties.

I don't know exactly where should I enter the expression.

So I have as Box field City,  as X-AXIS the Date and on the measure the averge of sales(avg sales).

Normally if no data/interval of data is selected I would show the last 6 days. If I put on the X-AXIS the expresion my boxplot breaks and I get "the chart is not displayed because it contains only undefined values"

Expression the X-AXIS  for the last 6 days

=IF(GetSelectedCount(DateAll)>0, Date(DateAll,'DD-MMM'),
if(DateAll<='$(=YESTERDAY)' and DateAll>='$(=YESTERDAY-6)',Date(DateAll,'DD-MMM')))

What am I missing here? AmI suppose to use an agg on the avg(sales) ?

Labels (2)
0 Replies