topic Re: set expression for current selected month to current month line chart in QlikView

set expression for current selected month to current month line chart

Thu, 18 Sep 2014 12:14:02 GMT

I am using line chart

dimension : month

expression : sum(TurnOver)

If user select a month in selection box, I want to get the data from the user selected month to current month

How can I achieve using set analysis? can you guys give some suggestions please?

Re: set expression for current selected month to current month line chart

MK_QSL — Thu, 18 Sep 2014 12:58:24 GMT

SUM({$<Month = {'>=$(=Max(Month))<=$(=Month(Today()))'}>}TurnOver)

SUM({$<Month = {'>=$(=Max(Month))<=$(=NUM(Month(Today())))'}>}TurnOver)

Re: set expression for current selected month to current month line chart

Anonymous — Thu, 18 Sep 2014 13:16:20 GMT

See if this is what you need

Re: set expression for current selected month to current month line chart

Fri, 19 Sep 2014 04:09:28 GMT

While applying same SET expression as you mentioned, I am getting No data to display error.

Can you please help me on this??

Re: Re: set expression for current selected month to current month line chart

PrashantSangle — Fri, 19 Sep 2014 04:52:27 GMT

Hi,

You have to do lots of changes.

1: Your Set Analysis Syntax was wrong.

Please find attached file for your reference.

It might help you

Regards,

Re: set expression for current selected month to current month line chart

jagan — Fri, 19 Sep 2014 05:13:05 GMT

Hi,

Try this script

Data:

LOAD * ,

Date(Date#(Month &' '&Year,'MMM YYYY')) as Date

INLINE [

Year, Month, turnover

2013, Jan, 100

2013, Feb, 120

2013, Mar, 152

2013, Apr, 654

2013, May, 254

2013, Jun, 345

2013, Jul, 0646

2013, Aug, 545

2013, Sep, 4123

2013, Oct, 446

2013, Nov, 8984

2013, Dec, 65456

2014, Jan, 64646

2014, Feb, 65456

2014, Mar, 465

2014, Apr, 8789

2014, May, 656

2014, Jun, 987

2014, Jul, 456

2014, Aug, 989

2014, Sep, 4966

];

Try this expression

=sum({<Date={">=$(=Date(Max(Date)))<=$(=Today())"},Year=,Month=>} turnover)

Hope this helps you.

Regards,

Jagan.