topic Re: Present Month Sales Calculation in pixel perfect in Qlik NPrinting

Present Month Sales Calculation in pixel perfect

ecabanas — Thu, 01 Oct 2015 16:10:44 GMT

Hi,

I have a Pixel perfect report with a full year sales filter . I would like to have a box or label with the current month sales, anyone knows how to do it? that's why because my report is filtered different from this request..

Many many thank's

PS: Is it possible to configure one connection with several filters in the same Pixel report?

Eduard

Re: Present Month Sales Calculation in pixel perfect

lironbaram — Thu, 01 Oct 2015 18:12:36 GMT

actually it's quite easy in your case

you can create a formula in the report

that should look something like this:

=text(money( sum({<Month={"$(=max(Month))"}>}Sales), '$ #,##0', '.' , ',' ))

then you can drag and drop your formula to the report

Re: Present Month Sales Calculation in pixel perfect

Thu, 01 Oct 2015 18:24:34 GMT

on the left side of the tempalte, create a formula which is an expression to get the current month - you can then drag the formula to the coation in the report

e.g. =month(today()) - this would be your formula to get the current month, for example - then drag the formula created onto the report template

Liron's information is much more specific and contains exactly what you are looking for

Re: Present Month Sales Calculation in pixel perfect

Thu, 01 Oct 2015 18:25:51 GMT

..and yes, you can have multiple filters for a single connection.

The connection points to a specific qvw, so as long as the field, variable etc you want to use for your filters is in that one qvw, it is not an issue