Problem mit KPI

[Manuel174102]

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

[JHuis]

Like this:

=Count({<[Sales_Invoice_Header.Posting Date] ={'>01.01.2017'}>} [Sales_Invoice_Header.Order No_])

[Manuel174102]

when I do that, I get a 0 😞 

[JHuis]

Dear Manuel,

are you using a master calender? 

[Manuel174102]

I do not know, sorry I am new in this

[JHuis]

https://community.qlik.com/t5/QlikView-App-Dev/Creating-A-Master-Calendar/td-p/341286

Use this, then it would work. 

[Manuel174102]

it is not working, if anyone has another solution, i would appreciate it!

[JHuis]

Dear Manuel,

can i get a sample of your data in excel ? Then i could resolve it within a app. 

[Manuel174102]

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

[JHuis]

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?