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: 
shamsu_mk
Creator
Creator

Multi dimension chart

Dear Team

I am facing some problem to make a chart in QV as mentioned below. Excel data also enclosed. Please help

DocPosted.JPG

Labels (1)
2 Solutions

Accepted Solutions
shamsu_mk
Creator
Creator
Author

Thank you it worked well. I have some other issue with dates. I will post it as separate topic

View solution in original post

dplr-rn
Partner - Master III
Partner - Master III

Sounds good. Please mark as answered and close the thread

View solution in original post

8 Replies
rahulpawarb
Specialist III
Specialist III

May be this:

Dimensions:

Days

Expressions:

//Doc. Date

Sum([Doc. Date])

//Pstng Date

Sum([Pstng Date])

shamsu_mk
Creator
Creator
Author

I think my question is nor clear or not in full. Can I explain more?

There are two fields called Doc Date and Posting Date and there is an expression is a total number of documents.

There 108 documents received on different dates and 108 documents processed(posted) on different dates. I want to show this in one chart that how many documents received in a day and how many processed on the same day?

 

DocPosted.JPG

shamsu_mk
Creator
Creator
Author

One example as on 16th Aug there was 11 document received whereas processed only 2 documents.

dplr-rn
Partner - Master III
Partner - Master III

I believe you need canonical date i.e. a common date tablr which will link your 2 date field s.
Would share the post by henric but with community redesign i am not able to find it.good luck
shamsu_mk
Creator
Creator
Author

Yes, Little difficult to search for things due to the redesigning of the community. Anyway, let us anyone else will help on this matter. If I get a qvw file it will be great.

shamsu_mk
Creator
Creator
Author

Thank you it worked well. I have some other issue with dates. I will post it as separate topic

dplr-rn
Partner - Master III
Partner - Master III

Sounds good. Please mark as answered and close the thread