topic Re: Creating a KPI from Data within two separate fields in QlikView

Creating a KPI from Data within two separate fields

wschefter — Wed, 25 Nov 2020 16:16:04 GMT

Hi all;

Still a semi-newbie...

I am trying to create a KPI that looks at the previous month only pulling specific data from two different fields. The first field name is "Spec.Stock" and the choices are as follows:

Whse Stock

Consignment

Stock @ Vendor

The second is my values from the field EUR.

This is the expression I have written for a different KPI that looked at the values for the previous months out of field EUR:

sum({<[=[Month.autoCalendar.MonthsAgo]={1}>}EUR)

This worked as planned but what I have been unable to figure out is how to write the expression to just pull the values from the field EUR for "Whse Stock" from "Spec. Stock".

Any advice or pointing me at the correct discussion/stream would be greatly appreciated.

Thanks in advance.

Re: Creating a KPI from Data within two separate fields

sunny_talwar — Sat, 17 Mar 2018 00:09:06 GMT

May be this

Sum({<[=[Month.autoCalendar.MonthsAgo] = {1}, [Spec. Stock] = {'Whse Stock'}>}EUR)

Re: Creating a KPI from Data within two separate fields

Qrishna — Sat, 17 Mar 2018 01:22:06 GMT

Sum({$<[Spec. Stock] = {'Whse Stock'}>}EUR) - this expression pulls EUR choices where [Spec. Stock] = {'Whse Stock'} and sums it up.

If u need more filters like month=xyz etc, just keep on adding as suggested above by sunny.

Re: Creating a KPI from Data within two separate fields

shiveshsingh — Sat, 17 Mar 2018 02:43:02 GMT

Add those fields in you set expression.

sum({<[=[Month.autoCalendar.MonthsAgo]={1}, [Spec. Stock] = {'Whse Stock'} >}EUR)

Re: Creating a KPI from Data within two separate fields

sasiparupudi1 — Mon, 19 Mar 2018 13:23:18 GMT

Sum({<[Spec. Stock]={'Whse Stock'}>}EUR)

Re: Creating a KPI from Data within two separate fields

wschefter — Mon, 19 Mar 2018 20:36:22 GMT

All of you, thank you very much. This is exactly what I needed. As I keep learning hopefully I will not need to keep asking these simple questions.

Again, thanks, I really appreciate it.

Will