topic Re: Filter on a measure in App Development

Filter on a measure

PabloMC — Sat, 16 Nov 2024 06:38:15 GMT

Hi everybody.

An user ask us to make himself a measure based on a filter. It is possible?

If we have one dimension (Country) and one measure (Sales), could him make a chart with "total sales" vs "Germany Sales" without making an specific measure for Germany?

Thanks in advance.

Re: Filter on a measure

pradosh_thakur — Fri, 08 Feb 2019 14:16:36 GMT

Sum({<Country={'Germany'>}Sales) will give you sales for germany. Is this what you wanted.

Please check the field names and value or it may throw an error.

Re: Filter on a measure

sunny_talwar — Fri, 08 Feb 2019 14:17:00 GMT

Sure, you can use set analysis for this

Total Sales

Sum(Sales)

Germany Sales

Sum({<Country = {'Germany'}>}Sales)

Re: Filter on a measure

PabloMC — Mon, 11 Feb 2019 08:45:59 GMT

I'm sorry but I can't use set analysis.

We have a master measure named SALES and we want to know how can the user use this unique measures in both cases, Total sales and Germany Sales in the same chart

Thanks

Re: Filter on a measure

pradosh_thakur — Mon, 11 Feb 2019 09:08:34 GMT

Why not create another master measure for user called GermanySales, they can drag Germany sales to see the total. I can't think of any other than changing the script that could do this. It would be easier if you create it in the UI.

Re: Filter on a measure

PabloMC — Mon, 11 Feb 2019 09:13:31 GMT

Because Germany is just an example. They want to make comparisons between a country(Germany, Italy, USA...) and the Total Sales.

Thanks

Re: Filter on a measure

sunny_talwar — Mon, 11 Feb 2019 12:18:25 GMT

I think I fail to understand what you are trying to do. Why can't you use set analysis here? Can you share a flow of events that will happen and what you would want to see at the end?

Re: Filter on a measure

PabloMC — Mon, 11 Feb 2019 12:52:46 GMT

We have a data set like this. Sales by country and month.

And we want to do something like this, but with only one expression. We don't want an expression for each country because we have sales, quantity, ebit... and maybe 25 countries. It will make about 150 expressions.

Is there a way to the user drag the Sales expression and filter it by a country? Then we had Sales of a country vs Total sales

Re: Filter on a measure

sunny_talwar — Mon, 11 Feb 2019 13:18:21 GMT

Create a line chart with monthyear as first dimension and country as second dimension. and use Sum(Sales) as expression. Now go to Dimension limits tab and check box for the total.

Re: Filter on a measure

pradosh_thakur — Mon, 11 Feb 2019 13:48:12 GMT

If you are using Qliksense do the following

add the below to the script

load * inline [

dim

1

2

];

Reload

Add below as your dimension

First dimension [Month Year]

Second dimension pick(dim, Country,'Total')

Expression

Sum(Sales)