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

Finding Quarter,Month and Year

Hello everyone,

a client share his file in the format like below,and he wants all his KPIs which he shared in Quarter,month and year vise.Iam not able to understand how I find quarter,month and year from the table.I applied crosstable but it wont work.please anyone has any idea share with me.Its urgent.

Dimension
Sum of Q1Sum of Q2Sum of Q3Sum of Q4Year 2012-13
Cost200410110200

920

Expense100120130100450
Rent200100100100500
Tax400100200300

1000

now requirement is to show tax quarter,month and year vise.But how to create quarter,month and year from above shared data.

1 Solution

Accepted Solutions
Not applicable
Author

Attached is an example on how to approach this. You can't do at month level because the data provided is aggregated at Quarter level.If Q1 is July, Aug, Sep and its cost is 200 how would you know whats the split for those three individual months.

Please check with the users on that.

Thanks

View solution in original post

2 Replies
ecolomer
Master II
Master II

You can use the jerarquico group

I attached a example

Not applicable
Author

Attached is an example on how to approach this. You can't do at month level because the data provided is aggregated at Quarter level.If Q1 is July, Aug, Sep and its cost is 200 how would you know whats the split for those three individual months.

Please check with the users on that.

Thanks