topic Re: Problem mit KPI in App Development

Problem mit KPI

Manuel174102 — Mon, 08 Aug 2022 11:56:39 GMT

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

Re: Problem mit KPI

JHuis — Mon, 08 Aug 2022 11:58:25 GMT

Like this:

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

Re: Problem mit KPI

Manuel174102 — Mon, 08 Aug 2022 12:22:02 GMT

when I do that, I get a 0 😞

Re: Problem mit KPI

JHuis — Mon, 08 Aug 2022 12:37:41 GMT

Dear Manuel,

are you using a master calender?

Re: Problem mit KPI

Manuel174102 — Mon, 08 Aug 2022 12:43:56 GMT

I do not know, sorry I am new in this

Re: Problem mit KPI

JHuis — Mon, 08 Aug 2022 12:56:38 GMT

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

Use this, then it would work.

Re: Problem mit KPI

Manuel174102 — Mon, 08 Aug 2022 13:42:00 GMT

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

Re: Problem mit KPI

JHuis — Mon, 08 Aug 2022 14:01:14 GMT

Dear Manuel,

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

Re: Problem mit KPI

Manuel174102 — Mon, 08 Aug 2022 14:11:51 GMT

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

Re: Problem mit KPI

JHuis — Mon, 08 Aug 2022 14:39:45 GMT

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?

Re: Problem mit KPI

Manuel174102 — Mon, 08 Aug 2022 14:50:32 GMT

But the KPI does not allow a dimension, I can only write a measure

Re: Problem mit KPI

JHuis — Tue, 09 Aug 2022 06:15:36 GMT

Dear Manuel,

An count or Sum is a measure?