Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
Go to Solution.
Here you have without aggr
In previous version i loaded null records. This is why i had aggr.
How's your actual data. If they are as per the excel file, it's difficult to work.
Explain in detail plz
I HAVE MY DATA IN A ORACLE TABLE.
TO BE SIMPLE I HAVE IN A PIVOT TABLE.
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.
Can you provide data in excel file as per mentioned above...
Try this code in text object
here, my blank field name which having value also is Data
or to count num month
Here the example.!!
For the number of months with data:
for the number of months in year
how do you put in that specific side in the pivot table?
Hi, try this.