topic Re: Logical line chart in QlikView

Logical line chart

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,
I need to show a cummulative line chart but with some logic .

Normally cummulative will kepp on adding its previous values to the current one .

I want to show a cummulative line chart of tickets by Week Start.
and my out put should be like shwon below .
Here on 2-Feb-2020 I had a ticket opened therefore the cummulative of 2 is showing on 9th and 16-Feb-2020
(As there are no records on these weeks) but on 23-Feb-2020 there is a ticket therefore the line chart should
show me 1 ticket on 23-Feb-2020 and for nex week thtere are no tickets then it should continue showing 1 only
that is on 1-Mar-2020 it show one .

How do I achiev this ? as of now my cummulative is adding everything and shwoing up .

My formula is like this :

rangeSum(above(TOTAL count(Tickets),0,RowNo(TOTAL)))

My Line chart should like the below one

output:

Week Start Tickets
2-Feb-2020 2
9-Feb-2020 2
16-Feb-2020 2
23-Feb-2020 1
1-Mar-2020 1
8-Mar-2020 4
15-Mar-2020 1

Thanks in Advance

Re: Logical line chart

smilingjohn — Wed, 18 Mar 2020 14:39:46 GMT

Hi All,

Any Solution on this would be really helpfull .

Thanks

Re: Logical line chart

smilingjohn — Thu, 19 Mar 2020 18:03:07 GMT

Hi Expertise any help

Re: Logical line chart

anushree1 — Thu, 19 Mar 2020 18:11:51 GMT

The requirement is not very clear , could you provide a sample input and also the desired output for a better understanding?

Re: Logical line chart

smilingjohn — Thu, 19 Mar 2020 19:22:43 GMT

Hi Anushree

I have to show ticets by every weekstart.

I dimensions I use weekstart and expression have count (ticket).

My weekstart are like , 9-feb2020,15-feb-2010 23-feb-2020

Now if my ticket is opene on 9th-feb-202 then the trend line should show 2 tickets on 15 and 23 -feb as well . And say for example on 1 mar-2020 another tickets tickets opens then the 1 ticket shoulg be shown till all the weekstart unless there is any open ticket to any weekstart.

Thanks