Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor II

Show all irrespective of selections

HI all,

i have data like

DeptNameSalDate
FINKL25020/7/2018
HRDEF8030/8/2018
ITABC1001/9/2018
ITHG1802/9/2018

‌ if I select a date it should show data for that date and for rest, it should show as zero.

ex: selected 1/9/2018

below is expected output

DeptNamesal
FINKL 0
HRDEF0
ITABC100
ITHG0
Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Show all irrespective of selections

Say you are using expression Sum(sal) for sal calculation. Re-write it like:

=Sum(val)*Avg({1} 1)



And, uncheck 'Supress zero values' in presentation tab.

View solution in original post

3 Replies
Highlighted
MVP
MVP

Re: Show all irrespective of selections

Say you are using expression Sum(sal) for sal calculation. Re-write it like:

=Sum(val)*Avg({1} 1)



And, uncheck 'Supress zero values' in presentation tab.

View solution in original post

Partner
Partner

Re: Show all irrespective of selections

Highlighted
Contributor II

Re: Show all irrespective of selections

‌perfect thanks Tresesco.

I Tried with Avg(1). But no luck.

Thank you