topic Re: Filter a calculation in App Development

Filter a calculation

stekol61 — Thu, 07 Mar 2019 15:00:01 GMT

I have added a filter to my app and i want to be able present result from this expression for different countries (wor_Country_S).

What is the best way to do this?

Count({<Week_S={'$(v_currentWeek)'} , wor_country_S >} wor_ticket_ID_S)

Re: Filter a calculation

rwunderlich — Thu, 07 Mar 2019 15:25:14 GMT

If you want to show for each country, the simplest method is to create a table chart with wor_Country_S as DImension.

If you want calculate for a specific country, for example in a KPI, add the country name into your set analysis.

Count({<Week_S={'$(v_currentWeek)'} , wor_country_S={'Austria'} >} wor_ticket_ID_S)

BTW, I'm not sure why you have wor_country_S by itself in the expression you posted.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Filter a calculation

stekol61 — Thu, 07 Mar 2019 15:35:27 GMT

I will present the result as a 'KPI' and want to select any of six different countries.

Should a use set analysis for that?

I use wor_country_S by itself in the expression just for test purpose to present the result for all countries in a table.

Re: Filter a calculation

rwunderlich — Thu, 07 Mar 2019 16:20:10 GMT

You don't need any set analysis for the country. Just create a filterbox and let the user select. Only selected countries will be included in the KPI.

-Rob

Re: Filter a calculation

stekol61 — Fri, 08 Mar 2019 08:50:29 GMT

Hi!

Count({<Week_S={'$(v_currentWeek)'} , wor_country_S >} wor_ticket_ID_S)

I removed 'wor_country_S' from the expression and then i can filter per Country.

Similar problem with my second expression.

Hardcode country as below work.

How can I get the Country filter works for this expression?

MinString({<new_cur_week = {'$(v_currentWeek)'}>}SE)

Re: Filter a calculation

stekol61 — Fri, 08 Mar 2019 09:40:12 GMT

Hi!

What might complicate the expression is the format of the data loaded

(MinString({<new_cur_week = {'$(v_currentWeek)'}>}SE))

	SE	FI	NO	EE	LT
2019-6	104	32	37	27	12
2019-7	104	32	37	27	12
2019-8	104	32	37	27	12
2019-9	101	31	36	26	12
2019-10	94	29	33	24	11
2019-11	94	29	33	24	11
2019-12	94	29	33	24	11

LOAD
F1 as new_cur_week,
SE,
FI,
NO,
EE,
LT
FROM

LET v_currentWeek = Replace(weekname(today()),'/','-');

Re: Filter a calculation

stekol61 — Fri, 08 Mar 2019 12:25:43 GMT

i solved this by:
f ((wor_country_S= 'SE'), (MinString({<new_cur_week = {'$(v_currentWeek)'}>}SE)),
If ((wor_country_S= 'NO'), (MinString({<new_cur_week = {'$(v_currentWeek)'}>}NO)),
If ((wor_country_S= 'FI'), (MinString({<new_cur_week = {'$(v_currentWeek)'}>}FI)),
If ((wor_country_S= 'EE'), (MinString({<new_cur_week = {'$(v_currentWeek)'}>}EE)),
If ((wor_country_S= 'LT'), (MinString({<new_cur_week = {'$(v_currentWeek)'}>}LT)),0)))))

Re: Filter a calculation

rwunderlich — Fri, 08 Mar 2019 15:37:33 GMT

You may want to consider loading this data with a CrossTable load.

CrossTable(Country, TicketCount)
LOAD F1 as new_cur_week,
SE,
FI,
NO,
EE,
LT
FROM

Which will produce a data table like this:

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com