topic Re: Fields As Measures in App Development

Fields As Measures

AMorella — Mon, 25 Mar 2024 14:39:44 GMT

Is there a way to have non-aggregated data show as bars in a combo graph?

I'm building an app to track stock level activity by product group (multiple SKUs). The plan is to compare year over year activity by taking the End Inventory for each year. I want to show the current year, previous year and delta for each product group.

The issue I'm having is there is one End Inventory number for each product group and I don't know how to make it graph because Qlik seems to require a calculation to do this (Sum, Count, etc.).

For the "measure", I'm using {<[Activity.Inv Type] = {"Import"}>} [Activity.End TCO]

Any help would be very much appreciated!

Re: Fields As Measures

Or — Mon, 25 Mar 2024 15:26:23 GMT

A measure is always aggregated, but you can use Only() as an aggregation.

Re: Fields As Measures

AMorella — Mon, 25 Mar 2024 15:38:04 GMT

I tried Only([Activity.End TCO]) and it doesn't graph. No value is given unless I sum.

Re: Fields As Measures

anat — Mon, 25 Mar 2024 15:43:05 GMT

Only() returns a value if there is one and only one possible result from the aggregated data. For example, searching for the only product where the unit price =9 will return NULL if more than one product has a unit price of 9.

Re: Fields As Measures

AMorella — Mon, 25 Mar 2024 15:51:50 GMT

OK, thank you. My issue is there's 1 data point for each product group for each month of the year. I need only the most recent one for each year to be shown (when looking at the year). So, December, and the most recent month for the current year.

The graph shows data in year format but can be broken down to monthly. Is there a way to show 12/2023 and 2/2024 (for example) in the "Year" view; and then have the "Month" view still show the individual month data?

Re: Fields As Measures

Or — Mon, 25 Mar 2024 16:43:06 GMT

Have a look at using FirstSortedValue(), then, perhaps.

Re: Fields As Measures

AMorella — Mon, 25 Mar 2024 18:41:49 GMT

Or,

Unfortunately, that gives no value. I took out the conditions and just went for the total value, sorted by Month - which is a numeric field - but it doesn't produce a result. The result is "The chart is not displayed because it contains only undefined values.

Code:

{<[Activity.Inv Type] = {"Location"}>} FirstSortedValue([Activity.End TCO] ,[Activity.Month], 12)

Meant to show December ending inventory, based on the named location.