Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
So I am showing the amount of sales since 2015.
The thing is, I only want to show the sales since 2017.
How could I do that?
I tried the following, but it did not work:
=Count({<[Sales_Invoice_Header.Posting Date] > {'01.01.2017'}>} [Sales_Invoice_Header.Order No_])
Greetings,
Manuel
Like this:
=Count({<[Sales_Invoice_Header.Posting Date] ={'>01.01.2017'}>} [Sales_Invoice_Header.Order No_])
when I do that, I get a 0 😞
Dear Manuel,
are you using a master calender?
I do not know, sorry I am new in this
https://community.qlik.com/t5/QlikView-App-Dev/Creating-A-Master-Calendar/td-p/341286
Use this, then it would work.
it is not working, if anyone has another solution, i would appreciate it!
Dear Manuel,
can i get a sample of your data in excel ? Then i could resolve it within a app.
Thanks for the offer but I can not. I do not have the data on an excel, I have it on another program which is connected to an SAP system. It is sadly not possible
create a new app:
Load * Inline [
Sales_Invoice_Header.Posting Date ,Sales_Invoice_Header.Order No_
1-1-2015 , 15
1-1-2016 , 16
1-1-2017 , 17
1-1-2018 , 18
1-1-2019 , 19
1-1-2020 , 20
1-1-2021 , 21
1-1-2022 , 22
];
add the date as an dimension and then this as a measure:
Sum({< [Sales_Invoice_Header.Posting Date]={">=1-1-2017"}>}[Sales_Invoice_Header.Order No_])
A sum is better then a count for an amount i guess. Maybe this works?