Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
brunolelli87
Creator II
Creator II

Why am I getting the "No Data do Display" message on charts?

Hello guys,

I used to have the following charts, working with the following Dimension and Expression:

Working.png

Dimension: =Date(DACG, 'DD/MM/YY')
Expression: =avg({1<STCK={'GOLL4'}, DACG={">$(=Date(Addmonths(Today(), -3)))"}>} VDAF)

For your information, if I try to use =avg(VDAF), than it works, but of course, it's not what I'm looking for. I would like to show the last 3 months of chart. Not the whole period.

 

But now it's working, look at that:

No data to display.png

What's going on?
How can I solve it? 

 

1 Solution

Accepted Solutions
brunolelli87
Creator II
Creator II
Author

I just changed CVPG to PERI (another date field), and it's working now!

 

View solution in original post

1 Reply
brunolelli87
Creator II
Creator II
Author

I just changed CVPG to PERI (another date field), and it's working now!