topic Re: line chart issue in QlikView

line chart issue

Wed, 20 Apr 2016 16:42:24 GMT

i have one table like below

now i want to show next month (May) value 50 for reaming month

how to show output in line chart please help

Input for line chart

Month amount

Jan 10

feb 20

mar 30

apr 40

may 50

jun 30

jul 45

aug 65

sep 75

oct 80

nov 90

dec 100

Output for line chart

Jan	10
feb	20
mar	30
apr	40
may	50
jun	50
jul	50
aug	50
sep	50
oct	50
nov	50
dec	50

Re: line chart issue

sunny_talwar — Wed, 20 Apr 2016 16:50:01 GMT

May be this:

=If(Month > Month(AddMonths(Today(), 1)), Above([Exp Name]), Sum(amount))

Where [Exp Name] is the name of your expression

Re: line chart issue

johnw — Wed, 20 Apr 2016 17:21:25 GMT

I try to avoid using above(), since it will not produce the same results if you make different selections. If you select only future months, for instance, you won't see any data. If you select April and July, you'll see 40 for July instead of 50.

I also like my months to be month/years, even if displayed as months. I like to be able to use date functions on them. I wouldn't do that for same month in multiple years comparisons, of course.

Anyway, something like this:

if(Month<monthstart(today(),1),sum(Amount),sum({<Month={'$(=month(monthstart(today(),1)))'}>} total Amount))

Re: line chart issue

sunny_talwar — Wed, 20 Apr 2016 17:39:32 GMT

Good idea John. I guess I was not sure how this was going to be used, but I agree that using Above() can be an issue when we are making selections .

Jan	10
feb	20
mar	30
apr	40
may	50
jun	50
jul	50
aug	50
sep	50
oct	50
nov	50
dec	50

Jan	10
feb	20
mar	30
apr	40
may	50
jun	50
jul	50
aug	50
sep	50
oct	50
nov	50
dec	50

Jan	10
feb	20
mar	30
apr	40
may	50
jun	50
jul	50
aug	50
sep	50
oct	50
nov	50
dec	50