topic Help YTD,MTD,QTD in QlikView

Help YTD,MTD,QTD

NavinReddy — Sat, 20 Jul 2013 06:49:37 GMT

Hi community,

Could some help me

I want to know YTD,MTD,QTD

some one explain me with one example,im using persional edition

how can we use these and apply

with one excel sheet

Thanks in Advance

rohith

NavinReddy — Sat, 20 Jul 2013 07:05:11 GMT

Hi mohit,

i already gone through that i can't able to understand

if any some example

thanks,

rohith

er_mohit — Sat, 20 Jul 2013 07:21:53 GMT

ok then load this excel file

and in script write

LOAD

date(Date,'MMM-YYYY')AS DATE,

date(Date,'DD-MM-YYYY')AS Date,

MONTH(Date)as Month,

Year(Date) as Year,

Sale

FROM

(ooxml, embedded labels, table is Sheet1);

and then use one bar chart for YTD

use dimension DATE for both bar chart

write expression

//YTD:

sum({<Date = {">=$(=YearStart(max(Date))) <=$(=max(Date))"},Year =, Month = >} Sale)

and one bar chart for MTD

Sum({<Date = {">=$(=MonthStart(max(Date))) <=$(=Monthend(max(Date)))"}, Year =, Month = >} Sale)

tresB — Sat, 20 Jul 2013 07:23:00 GMT

Learnt YTD, MTD, QTD here in general, Then to achieve the same in QV read this .

NavinReddy — Sat, 20 Jul 2013 08:39:46 GMT

Hi mohit,

Thank you very much

Plz find the attachment,let me know if i roung

Thanks,

rohith