Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Num of colum with and without data

I need to reproduce the execel that i atach.

I need know hoe to calculate Num Month, and Nun Month data

Basically num month will count num of month by year, and num month data count the num of month dhata have data.

Thanks in advance.

1 Solution

Accepted Solutions
Not applicable
Author

Here you have without aggr

In previous version i loaded null records. This is why i had aggr.

View solution in original post

18 Replies
MK_QSL
MVP
MVP

How's your actual data. If they are as per the excel file, it's difficult to work.

sujeetsingh
Master III
Master III

Explain in detail plz

Not applicable
Author

I HAVE MY DATA IN A ORACLE TABLE.

TO BE SIMPLE I HAVE IN A PIVOT TABLE.

DIMENSION.

YEAR

MONTH

CONTACT

AND EXPRESSION

SUM(SALES1 +SALES2 + SALES3)

I can do all the excel expect to column i am asking. Num of month and num of month with data.

Regards

MK_QSL
MVP
MVP

Can you provide data in excel file as per mentioned above...

er_mohit
Master II
Master II

Try this code in text object

here, my blank field name which having value also is Data

=count(if(len(Data)>0,Data))

or to count num month

Try this

=count(Month)

Not applicable
Author

Here the example.!!

Thanks!

bertdijks
Partner - Contributor III
Partner - Contributor III

For the number of months with data:

=NumericCount(data)

for the number of months in year

=count( MONTH)

Not applicable
Author

how do you put in that specific side in the pivot table?

mato32188
Specialist
Specialist

Hi, try this.

ECG line chart is the most important visualization in your life.