topic Re: how to create a YTD visualization ? in QlikView

how to create a YTD visualization ?

Wed, 27 May 2015 04:49:49 GMT

How to make a visualization showing YTD Sales of each Salesman.

maxgro — Wed, 27 May 2015 20:44:12 GMT

LOAD

InYearToDate(MakeDate(Year,Month), Today(), 0) as YTD,

Year,

Month,

Product,

Sales,

Salesman,

Area,

Count

FROM

RobSalesFact.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

or this (same expression), dimensions YearMonth and Salesman

Thu, 28 May 2015 11:33:29 GMT

thanks a lot.

but my requirement is like, the bar chart should not affect when i select any year or month.

the chart should respond to only selection of columns other than year and month.

PrashantSangle — Thu, 28 May 2015 11:36:15 GMT

Hi,

Nullify the field which you want not to affect on expression

Sum({<YTD={"-1"},Year=,Month=>}Sales)

Regards

Thu, 28 May 2015 12:06:45 GMT

hey ! it works

thanks alot