How to exclude the filter selection on the straight table w.r.t. Dimension

[kakaderanjit53]

Hi Qlik Experts,

I have created a Dashboard in QlikSense,By using a straight table,in which displaying the categories and their totals wrt to amount and budget measures,but after selection of filters the total details(Categories) are not displaying,PFB details ,for more information,and kindly provide me the appropriate solution for how to restrict the dimensions after selection of filters:

1. Before filter Selection:

2. After Filter Selection:

In the 2nd screenshot after selection of filters the Totals of Categories are not appearing on the Qliksense dashboard.

please provide me solution for the same.

Thanks and regards,

Ranjit Kakade.

Message was edited by: RANJIT KAKADE

[sunny_talwar]

What is the difference to what I provided above?

[sunny_talwar]

I used a comparison tool to compare the two expressions.... the only thing that was different between the two expression is the last line

Mine

sum({1<MagCategoryName={'*'}-{"*Std"}>}$(vNetBalance)))))))))))))))))))))))

vs. yours

sum({1<MagCategoryName={'*'}-{"*Std"},[Business Unit Name]=,CompanyName=>}$(vNetBalance)))))))))))))))))))))))

Do you really need to ignore selections in ,[Business Unit Name]=,CompanyName= even though you are using 1 to ignore all selections?