Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ashmitp869
Creator
Creator

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

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.

 

 

 

1 Solution

Accepted Solutions
ashmitp869
Creator
Creator
Author

Hi All ,

I used the below expression in Add on

sam.PNG

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

 

It worked.

Thanks

View solution in original post

3 Replies
shivanisapkale
Partner
Partner

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
Specialist
Specialist

try like below in your expression

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

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

ashmitp869
Creator
Creator
Author

Hi All ,

I used the below expression in Add on

sam.PNG

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

 

It worked.

Thanks