Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Highlighted
Valued Contributor

Total Months are not appeared once cleared!

Dear Our Experts!

I have loaded data relating to (MAY,JUN,JULY,AUG,SEP & OCT) but what is appeared in the table except part of JUL & no data for  AUG,SEP & OCT. But if I select those Months individually using list box for Months, it is appeared. Can some one explain me the reason for that. I may present the excel too.

Thanks

Neville

      

Date/Month(As per the Plan)Person assigned for VisitBranch to be visitedAmmended_PlanPerson visitedBranch visited
18-May-17NevilleEmbilipitiya25-May-17NevilleEmbilipitiya
19-May-17NevilleKahawatta19-May-17
30-May-17NevilleGodakawela25-May-17NevilleGodakawela
30-May-17NevillePallebedda25-May-17NevillePallebedda
17-May-17VernonThanamalwila18-May-17VernonThanamalwila
23-May-17VernonKalawana23-May-17
19-May-17VernonPelmadulla19-May-17
22-May-17MaheshEheliyagoda19-May-17MaheshEheliyagoda
25-May-17MaheshKiriella19-May-17MaheshKiriella
22-May-17MaheshKuruwita19-May-17MaheshKuruwita
26-May-17IreshaMiddeniya23-May-17IreshaMiddeniya
26-May-17IreshaAngunakolapelessa23-May-17IreshaAngunakolapelessa
30-May-17IreshaBalangoda
20-Jun-17NevilleKiriella29-Jun-17NevilleKiriella
22-Jun-17NevilleKalawana26-Jun-17NevilleKalawana
28-Jun-17NevillePelmadulla27-Jun-17NevillePelmadulla
28-Jun-17NevilleBalangoda27-Jun-17NevilleBalangoda
23-Jun-17VernonEmbilipitiya26-Jun-17VernonEmbilipitiya
19-Jun-17VernonAngunakolapelessa20-Jun-17VernonAngunakolapelessa
19-Jun-17VernonGodakawela26-Jun-17VernonGodakawela
21-Jun-17MaheshMiddeniya27-Jun-17MaheshMiddeniya
26-Jun-17MaheshKahawatta23-Jun-17MaheshKahawatta
21-Jun-17MaheshPallebedda23-Jun-17MaheshPallebedda
22-Jun-17IreshaEheliyagoda22-Jun-17IreshaEheliyagoda
22-Jun-17IreshaKuruwita22-Jun-17IreshaKuruwita
27-Jun-17IreshaThanamalwilla27-Jun-17IreshaThanamalwilla
21-Jul-17NevilleEheliyagoda21-Jul-17NevilleEheliyagoda
19-Jul-17NevilleKiriella19-Jul-17NevilleKiriella
21-Jul-17NevilleKuruwita21-Jul-17NevilleKuruwita
27-Jul-17NevilleThanamalwila28-Jul-17 Thanamalwila
21-Jul-17VernonMiddeniya27-Jul-17VernonMiddeniya
19-Jul-17VernonAngunakolapeless27-Jul-17VernonAngunakolapeless
19-Jul-17VernonGodakawela26-Jul-17VernonGodakawela
20-Jul-17MaheshKalawana20-Jul-17MaheshKalawana
28-Jul-17MaheshPelmadulla28-Jul-17MaheshPelmadulla
28-Jul-17MaheshBalangoda28-Jul-17MaheshBalangoda
24-Jul-17IreshaEmbilipitiya24-Jul-17IreshaEmbilipitiya
26-Jul-17IreshaKahawatta21-Jul-17IreshaKahawatta
21-Jul-17IreshaPallebedda21-Jul-17IreshaPallebedda
22-Aug-17NevilleThanamalwila25-Aug-17NevilleThanamalwila
18-Aug-17NevilleKalawana18-Aug-17NevilleKalawana
25-Aug-17NevillePelmadulla22-Aug-17NevillePelmadulla
25-Aug-17NevilleBalangoda22-Aug-17NevilleBalangoda
24-Aug-17VernonEmbilipitiya24-Aug-17VernonEmbilipitiya
21-Aug-17VernonMiddeniya21-Aug-17VernonMiddeniya
21-Aug-17VernonPallebedda21-Aug-17VernonPallebedda
17-Aug-17MaheshEheliyagoda17-Aug-17MaheshEheliyagoda
23-Aug-17MaheshKiriella23-Aug-17MaheshKiriella
17-Aug-17MaheshKuruwita17-Aug-17MaheshKuruwita
30-Aug-17IreshaAngunakolapelessa29-Aug-17IreshaAngunakolapelessa
16-Aug-17IreshaKahawatta16-Aug-17IreshaKahawatta
30-Aug-17IreshaGodakawela16-Aug-17IreshaGodakawela
27-Sep-17NevilleEmbilipitiya25-Sep-17NevilleEmbilipitiya
21-Sep-17NevilleMiddeniya25-Sep-17NevilleMiddeniya
19-Sep-17NevilleThanamalwila19-Sep-17NevilleThanamalwila
21-Sep-17NevillePallebedda19-Sep-17NevillePallebedda
26-Sep-17VernonKalawana26-Sep-17VernonKalawana
20-Sep-17VernonPelmadulla20-Sep-17VernonPelmadulla
20-Sep-17VernonBalangoda20-Sep-17VernonBalangoda
29-Sep-17MaheshAngunakolapelessa27-Sep-17MaheshAngunakolapelessa
19-Sep-17MaheshKahawatta19-Sep-17MaheshKahawatta
21-Sep-17MaheshGodakawela27-Sep-17MaheshGodakawela
25-Sep-17IreshaEheliyagoda26-Sep-17IreshaEheliyagoda
21-Sep-17IreshaKiriella26-Sep-17IreshaKiriella
25-Sep-17IreshaKuruwita26-Sep-17IreshaKuruwita
25-Oct-17MaheshEheliyagoda25-Oct-17MaheshEheliyagoda
25-Oct-17MaheshKuruwita25-Oct-17MaheshKuruwita
27-Oct-17VernonEmbilipitiya27-Oct-17VernonEmbilipitiya
19-Oct-17VernonMiddeniya19-Oct-17VernonMiddeniya
25-Oct-17VernonThanamalwila25-Oct-17VernonThanamalwila
20-Oct-17IreshaAngunakolapelessa20-Oct-17IreshaAngunakolapelessa
17-Oct-17IreshaKahawatta17-Oct-17IreshaKahawatta
26-Oct-17NevilleKalawana24-Oct-17NevilleKalawana
20-Oct-17NevillePelmadulla20-Oct-17NevillePelmadulla
20-Oct-17IreshaGodakawela17-Oct-17IreshaGodakawela
27-Oct-17MaheshPallebedda27-Oct-17MaheshPallebedda
20-Oct-17NevilleBalangoda20-Oct-17NevilleBalangoda
19-Oct-17SinekaKiriella19-Oct-17SinekaKiriella
1 Solution

Accepted Solutions
Highlighted

Re: Total Months are not appeared once cleared!

Try this

SUM(AGGR(COUNT(DISTINCT([Person assigned for Visit])),[Branch to be visited],[Branch visited], SET_MONTH))

SUM(AGGR(COUNT(DISTINCT([Person visited])),[Branch visited],[Branch to be visited], SET_MONTH))

View solution in original post

5 Replies
Highlighted

Re: Total Months are not appeared once cleared!

Did you try to uncheck 'Suppress Zero Values' on the presentation tab of your chart properties?

Highlighted
Valued Contributor

Re: Total Months are not appeared once cleared!

Dear Sunny,

As you said when 0 values were unchecked, total Months are shown. But the two expressions I have written get the 0 values for most of the cases. But when each individual Months are selected picture is correct that too presented here. For you to check the expression too given.

SUM(AGGR(COUNT(DISTINCT([Person assigned for Visit])),[Branch to be visited],[Branch visited]))

SUM(AGGR(COUNT(DISTINCT([Person visited])),[Branch visited],[Branch to be visited]))

Thanks

Highlighted
Valued Contributor

Re: Total Months are not appeared once cleared!

Please let me know the reason as to why this happen so!

Highlighted

Re: Total Months are not appeared once cleared!

Try this

SUM(AGGR(COUNT(DISTINCT([Person assigned for Visit])),[Branch to be visited],[Branch visited], SET_MONTH))

SUM(AGGR(COUNT(DISTINCT([Person visited])),[Branch visited],[Branch to be visited], SET_MONTH))

View solution in original post

Valued Contributor

Re: Total Months are not appeared once cleared!

Thank you very much dear sunny!

Your answer worked well!. Of course it was very fine.

Neville