topic Multi dimension chart in QlikView

Multi dimension chart

shamsu_mk — Sat, 16 Nov 2024 05:11:39 GMT

Dear Team

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

Re: Multi dimension chart

rahulpawarb — Tue, 20 Nov 2018 10:18:47 GMT

May be this:

Dimensions:

Days

Expressions:

//Doc. Date

Sum([Doc. Date])

//Pstng Date

Sum([Pstng Date])

Re: Multi dimension chart

shamsu_mk — Tue, 20 Nov 2018 10:59:24 GMT

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?

Re: Multi dimension chart

shamsu_mk — Tue, 20 Nov 2018 11:03:05 GMT

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

Re: Multi dimension chart

dplr-rn — Tue, 20 Nov 2018 12:50:12 GMT

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

Re: Multi dimension chart

shamsu_mk — Tue, 20 Nov 2018 12:54:51 GMT

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.

Re: Multi dimension chart

dplr-rn — Tue, 20 Nov 2018 14:53:15 GMT

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

Re: Multi dimension chart

shamsu_mk — Fri, 30 Nov 2018 07:31:51 GMT

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

Re: Multi dimension chart

dplr-rn — Fri, 30 Nov 2018 12:17:20 GMT

Sounds good. Please mark as answered and close the thread