topic Year to date expression in QlikView

Year to date expression

raghavsurya — Tue, 17 Aug 2010 06:22:13 GMT

Hi All,

I have a requirement wherein I have monthly sales data. I need to represent YTD sales in a straight table chart. There is a list box provided for "Month". If the user clicks on May for example..... the table should show the sales from Jan to May. can anyone help me out with completing the YeartoDate expression.

All I need is to pick the total of field called "Samount" . I tried doing the expression but its not returning any values

"Yeartodate(17-08-2010,0,1,today(),sum(Samount))"

Can you please help me out.

Regards,

Raghav

Year to date expression

Tue, 17 Aug 2010 06:29:06 GMT

Hi,

In dimension, Date / Month field, you can define expression as

IF(Monthname(Date) < = getcurrentselections(), Dimension field, Null())

Suppress Null Values.

Happy Thoughts

Year to date expression

raghavsurya — Tue, 17 Aug 2010 06:38:52 GMT

Hi Ravi,

thanks for your input...... Please find below the expression I could write using your inputs. But its not returning any value....

Yeartodate(IF((Monthname(Date)<= getcurrentselections()),Customer,Null()),sum(Samount))

Can you please have a look.

Regards,

Raghav

Year to date expression

raghavsurya — Tue, 17 Aug 2010 06:59:15 GMT

Hi,

Please find attached the qvw file. Can you please help me to complete the YeartoDate expression.

Regards,

Raghav

Year to date expression

Tue, 17 Aug 2010 08:30:39 GMT

is that what u want ... look at it ...

Önder

Year to date expression

raghavsurya — Tue, 17 Aug 2010 08:40:53 GMT

Thanks Onder....... This is what I exactly wanted.

Regards,

Raghav