Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to have plot/line like this in Excel

Plotstyle.png

How can  Iacheive such plotting.

I have call Data : CallStartDate, Call %.

Thank You

2 Replies
Highlighted
Not applicable

Re: How to have plot/line like this in Excel

Hi,

So call % is your expressions, and  CallStartDate is your dimension. But there are three expressions in this case

  • Morning call
  • daily call
  • late reported call

You can create individual expressions and isolate the data using set analysis. Just search set analysis. It should help solve your problems.

Highlighted
Not applicable

Re: How to have plot/line like this in Excel

Any example, I have trie some expression, but still not working

Model.png

AM_PM correspond to time range  :

  • Morning call
  • daily call
  • late reported cal

Percentage is AVG(UTCount)

Thanks