Multi dimension chart

[shamsu_mk]

Dear Team

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

[rahulpawarb]

May be this:

Dimensions:

Days

Expressions:

//Doc. Date

Sum([Doc. Date])

//Pstng Date

Sum([Pstng Date])

[shamsu_mk]

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?

[shamsu_mk]

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

[dplr-rn]

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]

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.

[dplr-rn]

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

[shamsu_mk · Accepted solution]

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

[dplr-rn · Accepted solution]

Sounds good. Please mark as answered and close the thread