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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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