topic Re: Set analysis in App Development

Set analysis

GOKULAKANNAN — Wed, 17 Aug 2022 14:32:38 GMT

I have a table, table1:

load * inline
[
country,sales
india,10
afg,20
pak,30
aus,50
]

and am creating a KPI which should display the value sum(sales) for india, for that i have used set analysis

sum({<country={'india'}>}sales), Now my requirement is, by default it should show the sum(sales) for india, but when user made any selection it should show value for that(i.e if user selecting country aus, then it should show the value of 50) how can i acheieve that,

Re: Set analysis

brunobertels — Wed, 17 Aug 2022 15:07:02 GMT

Try this

if(isnull(
GetcurrentSelections(country)),
sum({<country={'india'}>}sales),
sum(sales))

Re: Set analysis

Sivapriya_d — Wed, 17 Aug 2022 16:45:12 GMT

Hi ,

Check if this helps.
If(GetSelectedCount(country)=0,Sum({<country={'india'}>}sales),Sum(sales))

Thanks,