Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Manuel174102
Creator
Creator

Problem mit KPI

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

Labels (1)
11 Replies
JHuis
Creator III
Creator III

Like this:

 

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

Manuel174102
Creator
Creator
Author

when I do that, I get a 0 😞 

JHuis
Creator III
Creator III

Dear Manuel,

are you using a master calender? 

Manuel174102
Creator
Creator
Author

I do not know, sorry I am new in this

JHuis
Creator III
Creator III

Manuel174102
Creator
Creator
Author

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

JHuis
Creator III
Creator III

Dear Manuel,

 

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

Manuel174102
Creator
Creator
Author

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
Creator III
Creator III

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?