topic Re: Excluding current month in chart in QlikView

Excluding current month in chart

Mon, 11 May 2015 12:10:03 GMT

Hi,

I want to exclude the current month in a graph, but keep all the data in the load.

My calcualtion in the graph is:

=sum( {$<Metric_Code={'RTT18'}>} Metric_Value)

I tried to use this calcualtion to exclude the current month but it hasnt made any difference. May is still showng the the graph:

sum({$<Metric_Code={'RTT18'}>} if (MonthYear <> monthname(today()), Metric_Value))

Can anyone help?

Re: Excluding current month in chart

PrashantSangle — Mon, 11 May 2015 12:12:40 GMT

Hi,

try like

sum( {$<Metric_Code={'RTT18'},MonthYear={"<$(=MonthName(Monthstart(Today())))"}>} Metric_Value)

Regards,

Re: Excluding current month in chart

Mon, 11 May 2015 13:24:45 GMT

This just makes the line on my graph completely disappear (?)

Re: Excluding current month in chart

Mon, 11 May 2015 13:29:08 GMT

Hi Kate,

I guess Month is one of your dimension.

So either use Dimension limits (according to your chart) or edit calculated dimension and state an IF(Month < $(vCurrrentMonth), Month)

vCurrentMonth must be defined. To make a test you can hard code first

best regards

Chris

Re: Excluding current month in chart

santhoo_san — Mon, 11 May 2015 13:33:16 GMT

you can try this

sum({$<Metric_Code={'RTT18'},MonthYear - ={"$(=MonthName(Monthstart(Today())))"}>} Metric_Value)

Re: Excluding current month in chart

PrashantSangle — Tue, 12 May 2015 05:10:57 GMT

Hi,

Can you post sample apps???

Regards

Re: Excluding current month in chart

danieloberbilli — Tue, 12 May 2015 05:29:19 GMT

Please find .QVW attached

Re: Excluding current month in chart

mohammadkhatimi — Tue, 12 May 2015 05:34:15 GMT

Hie...

Use function Exclude

Read below script

Indirect Set Analysis

• p( ) = Possible

• e( ) = Excluded

Excluded

Possible

Customer = p({<Year={$(=max(Year)-1)}>} Customer)

Returns customers who had an association to last year.

sum(({<Year={$(=max(Year))},

Customer = p({<Year={$(=max(Year)-1)} Customer>}) Sales)

Returns this year’s sales for customers who had sales last year

Indirect Set Analysis

sum({$<CompanyName = p({$<CategoryName={'Baby Clothes'}>}

CompanyName)>} Sales)

Sales for Customers who purchased Baby Clothes.

The set p({}) returns the values of CompanyName (Customer) that

purchased Baby Clothes.

sum({$<CompanyName = p({$<CategoryName={'Baby Clothes'}>}

CompanyName) - p({$<CategoryName={'SportsWear'}>}

CompanyName)>} Sales)

Sales for Customers who purchased Baby Clothes but not

Sportswear.The first set p({}) returns CompanyName that purchased

Baby Clothes.The second set p({}) returns CompanyName that

Purchased SportsWear.The Unary Operator "-" between the two gives

a list of Customers (Company Name)that belong to the first but not the

other set

Hope this helps you.

Regards,

Mohammad