Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
try like below in your expression
if( getselectedcount(FinancialYear])>=1, sum({<FinancialYear={$(=GetFieldSelections(FinancialYear))}>}Sales),
sum({<FinancialYear={$(=Max(FinancialYear))}>}Sales))
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