Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
stabdha91
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.

1 Solution

Accepted Solutions
Kushal_Chawda

Expression:

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


View solution in original post

2 Replies
Kushal_Chawda

Expression:

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


antoniotiman
Master III
Master III

Hi,

see Attachment.

Regards,

Antonio