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: 
khasimvali85
Creator II
Creator II

Adding Date day wise up to month end in Pivot

Hi Community,

I hope you are doing well.

I have facing to create the date to add daily in chart for month.

I have Date field with sales data with Branch and i want achieve in pivot chart , show branch wise data with month start date to end date.

Ex:  Branch | ASCName|  01/04/2016 |  02/04/2016 | 03/04/2016 | 04/04/2016|  05/04/2016   06/04/2016  07/04/2016|  08/04/2016| ....... up to end of the month and its every day add side by side up to month end.



Regards,

Khasim.

1 Solution

Accepted Solutions
khasimvali85
Creator II
Creator II
Author

Hi Sam,

Thanks Sam I am found the solution for this.

Created Variables  vStartDate and vMaxDate used in expressions like:

SUM(< { '>=$(vStartDate) <= $(vAMCDate)' } >}  Sales)  and use the date field in Dimension as you said.

Regards,

Khasim.

View solution in original post

9 Replies
mightyqlikers
Creator III
Creator III

hi,

add branch, year , month, day as dimension in pivot table and sum(sales) as expression.

and in presentation table  enable check box always fully expand ,

now drag and drop year dimension on top of expression like wise for month  and day.

$@M.

tresesco
MVP
MVP

May be using Crosstable()?  Could you share a sample data set?

khasimvali85
Creator II
Creator II
Author

Hi Sam,

Thanks for reply,

only add days staring to current date in pivot

khasimvali85
Creator II
Creator II
Author

Hi Treseco,

Thanks for Reply,

I have attached Rawdata in excel file with required format please check.

mightyqlikers
Creator III
Creator III

FYI,

$@M.

khasimvali85
Creator II
Creator II
Author

Hi Sam,

Thanks for the suggestion, my requirement is same like that,

but i have last 5 years of data and it will show you last 5 years dates as you designed way.

i want only one month i.e current month starting date to current date

Regards,

Khasim.

mightyqlikers
Creator III
Creator III

create year and month for the date feld in the back end

and use them as dimension as i have mentioned in the previus post.

$@M.

khasimvali85
Creator II
Creator II
Author

Hi Sam,

Thanks Sam I am found the solution for this.

Created Variables  vStartDate and vMaxDate used in expressions like:

SUM(< { '>=$(vStartDate) <= $(vAMCDate)' } >}  Sales)  and use the date field in Dimension as you said.

Regards,

Khasim.

sunny_talwar

If you got what you were looking for, I would suggest closing the thread by marking correct and helpful answers.

Best,

Sunny