Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Count in Pivot table.

Hi,

I have a scenario where i want my pivot table to show count as shown in the pic.

Date:

IDNameMonthflag
1qJan1
2aJan1
3zJan0
4xJan1
1qFeb1
2aFeb0
3zFeb0
4xFeb1
1qMar1
2aMar0
3zMar0
4xMar0

I am putting a green check image where ever flag=1 and i count i want to count number of flags for each month. I am pivoting the table on Month column.

Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Count in Pivot table.

Expression:

=if(Dimensionality()=0,Sum(flag), if(sum(flag)=1,'qmem://<bundled>/BuiltIn/check_g.png'))


View solution in original post

2 Replies
Highlighted
MVP
MVP

Re: Count in Pivot table.

Expression:

=if(Dimensionality()=0,Sum(flag), if(sum(flag)=1,'qmem://<bundled>/BuiltIn/check_g.png'))


View solution in original post

Highlighted
Master III
Master III

Re: Count in Pivot table.

Hi,

see Attachment.

Regards,

Antonio