topic Re: How to Plot this chart in QlikView

How to Plot this chart

Anonymous — Wed, 27 Aug 2014 05:48:23 GMT

Hi all,

PFA

With that dataset ,

Whether it is possible to plot a chart Month wise different Debits/Credits Accounts against particular selected Account.

Debit Plots will be in particular symbol

Credit Plots will be in another symbol

And Different Accounts will be in different colours

Wed, 27 Aug 2014 06:27:43 GMT

Yes it is possible,

Create a grid chart object

Select your dimension as month or date

create two expressions for Dr and Cr

in I the definition are of the expression write

for Cr definition sum({$<status={Cr}>}Amnt)

for Dr definition sum({$<status={Dr}>}Amnt)

Also on the axes tab you can Split the axes as you wish

hope this helps

AbhijitBansode — Wed, 27 Aug 2014 06:40:47 GMT

PFA.