Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Partner
Partner

Suppress one column in table and exclude its value from another column

Hello,
Can anyone help with below thing for me please?
My real project is very complicated. Image one branch has sold some product, so this branch and its benchmark group have some feagure while another branch in the same benchmark group has not sold that product. When we calculate the average sold product per branch for the benchmark goup, we should use total sold value divided by one branch, rather than two branches, shouldn't we?
Please see attached sample. Thanks a lot!
1) Dimension is Cycle group.

2) Must select a Branch. Then first expression shows the data for that branch and seconde expression shows the data for the Benchmark Group that the selected branch belongs to.

3) When the branch data is null but benchmark Group data is not null, that row cannot be suppressed automatically.

4) What I want is to suppress the rows with null value for Branch and also in the total number for Benchmarg Group, exclude the value for the branch that have been suppressed.
TransIDBranchBenchmark Group
Total118.9123.7
37.0 5.6
48.55.5
56.6
66.57.7
74.54.4
83.3
98.52.2
105.58.8
119.9
124.4
134.45.8
Tags (1)
2 Replies
Partner
Partner

Re: Suppress one column in table and exclude its value from another column

The other branch has not and will never sell that product. Just want to count the average for the branches that sells the product. Thanks.

Partner
Partner

Re: Suppress one column in table and exclude its value from another column

Sorry. My explaination is a little confusing. Please see the attached sample file. Thanks.