Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Oscar101
Contributor
Contributor

Set analysis is showing me all zero values from start date ( wrong auto calendar)

 

 

Hi

So i set an autocalendar in load editor. ( see below). But then when i do set analysis, it shows me correct values, but also all the zeros from start date.

Im using this, and i would want to tell me the euros of transactions from yesterday. And it is doing that but also all transaction from begining with zeros ( not just yesterdays)

Sum({<[OperFecha.autoCalendar.Date]={'$(=Date(Today(1)-1))'} >} LinNeto)

For example in this image 15 stads for a transaction of the year 2015!

 

I read somehwere i have to edit master calendar , but i cant remember, help please!

 

Oscar101_1-1688455579572.png

 

Here is the calendar

 

Oscar101_0-1688455408815.png

 

Labels (3)
0 Replies