Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Re: Num of colum with and without data

Here you have without aggr

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

18 Replies

Re: Num of colum with and without data

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

sujeetsingh
Honored Contributor III

Re: Num of colum with and without data

Explain in detail plz

Not applicable

Re: Num of colum with and without data

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

Re: Num of colum with and without data

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

er_mohit
Honored Contributor II

Re: Num of colum with and without data

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

Re: Re: Num of colum with and without data

Here the example.!!

Thanks!

bertdijks
New Contributor III

Re: Num of colum with and without data

For the number of months with data:

=NumericCount(data)

for the number of months in year

=count( MONTH)

Not applicable

Re: Re: Num of colum with and without data

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

mato32188
Contributor III

Re: Num of colum with and without data

Hi, try this.

Community Browser