Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
shamsu_mk
Contributor

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
Contributor

Re: Multi dimension chart

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

View solution in original post

Partner
Partner

Re: Multi dimension chart

Sounds good. Please mark as answered and close the thread

View solution in original post

8 Replies
rahulpawarb
Valued Contributor III

Re: Multi dimension chart

May be this:

Dimensions:

Days

Expressions:

//Doc. Date

Sum([Doc. Date])

//Pstng Date

Sum([Pstng Date])

shamsu_mk
Contributor

Re: Multi dimension chart

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
Contributor

Re: Multi dimension chart

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

Partner
Partner

Re: Multi dimension chart

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
Contributor

Re: Multi dimension chart

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.

Partner
Partner

Re: Multi dimension chart

shamsu_mk
Contributor

Re: Multi dimension chart

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

View solution in original post

Partner
Partner

Re: Multi dimension chart

Sounds good. Please mark as answered and close the thread

View solution in original post