restrict the data to show for only one Financial Year in my table chart ?

[ashmitp869]

Hi there,

I have used Table from Chart option in Qliksence and  my table chart with 330 columns. I want to restrict the data to show for only one Financial Year .

Is there any way I can used the calculation condition in Table chart in Qliksense to use the below expression=

i.e to show the table if only FinancialYear is selected ?
=if(getselectedcount(FinancialYear])=1,1,0)

I have Financial Year in my Filter pane.

[shivanisapkale]

Hello,

If you want only one financial year and if there is any measure present kindly add set analysis(YTD) on it.

Regards,

Shivani Sapkale

[NitinK7]

try like below in your expression

if(  getselectedcount(FinancialYear])>=1, sum({<FinancialYear={$(=GetFieldSelections(FinancialYear))}>}Sales),

sum({<FinancialYear={$(=Max(FinancialYear))}>}Sales))

[ashmitp869 · Accepted solution]

Hi All ,

I used the below expression in Add on

i.e to show the table if only FinancialYear is selected ?
=if(getselectedcount(FinancialYear])=1,1,0)

It worked.

Thanks