topic Re: Multiple filters with several combination in App Development

Multiple filters with several combination

selvakumara — Thu, 09 Nov 2017 04:34:40 GMT

Hi Guys,

I'm creating KPI using Qlik sense.

I have 4 filters called name, group, [fiscal year] , [year month].

if i select fiscal year i want to display the value for selected year only.

if i select [year month] i want to display the value for selected [Year month ]only.

if select name and group want to display the same.

Also sometimes user will select the following combination (name and group ) or (Fiscal year , Group) or ([Year month], Group)..... etc

any suggestions ???

Anonymous — Thu, 09 Nov 2017 05:23:56 GMT

one way is to use if else condition.

eg: if(getselectedcount( [fiscal year] )>0,sum({<name=, group=, [year month]=>}sales),

if(getselectedcount([year month] )>0,sum({<name=, group=, [fiscal year]=>}sales)

)

this way you can add different conditions

shraddha_g — Thu, 09 Nov 2017 05:49:17 GMT

is all your data associated?

If yes, sum(Value) will work.

If you select any of combinations then data will filter accordingly and value will be displayed.

selvakumara — Thu, 09 Nov 2017 07:02:29 GMT

as you mentioned

if i selected name and group as filter how it will work ?

Really i don't have any idea

Any suggestions ??

selvakumara — Thu, 09 Nov 2017 07:04:25 GMT

Also i have Donut chart with sub categories. if i select any sub categ , i dont want make any changes in my KPI

That's y i'm thinking

any ideas?