topic Re: Different Filter for each excel column in NPrinting in Qlik NPrinting

Different Filter for each excel column in NPrinting

Thu, 15 Sep 2016 13:02:50 GMT

Hi All

Currently i am using Nprinting version 15.3 for creating report on excel file.

I want to create a report a nprinting report based on my qlikview document,
What i want to achieve is someting like this

Formula	Current year	Last Year	Quarter 3	YTD
a+b	10	23	21	55
a+b+c	50	80	80	70
a+d+e	60	70	60	50
a+b+c+d+e	100	150	150	120

For now i should create a formula one by one per cell example :

for a+b current year = sum({<Formula={a+b},Year={2016}>}Sales)

a+b Last year = sum({<Formula={a+b},Year={2015}>}Sales)

a+b Quarter year = sum({<Formula={a+b},Quarter={"Q3"}Sales)

and for a+b+c

for a+b+c current year = sum({<Formula={a+b+c},Year={2016}>}Sales)

a+b+c Last year = sum({<Formula={a+b}+c,Year={2015}>}Sales)

a+b+c Quarter year = sum({<Formula={a+b+c},Quarter={"Q3"}Sales)

My Question is can i apply different filter for each column? Current Year column = 2016, Last Year Column = 2015 etc.....

currently i am using formula for showing the value.

Appreciate any help

Thanks

Re: Different Filter for each excel column in NPrinting

neelamsaroha157 — Thu, 15 Sep 2016 14:32:27 GMT

I couldn't understand what you want but may be this is waht you are looking for.

You can create parameterized variable for your 'Formula' column and use that variable in the expression.

Then you can pass different values of in your Formula column.

If not then provide a sample file to work on the sol'n

Re: Different Filter for each excel column in NPrinting

Anonymous — Thu, 15 Sep 2016 14:51:35 GMT

You can create these expressions in QlikView for these columns and bring them in Nprinting excel. It will give you results based on your Current Year, Last Year, Quarter and YTD expressions

Re: Different Filter for each excel column in NPrinting

Thu, 15 Sep 2016 15:08:11 GMT

Hi Neelam,

What i try to achieve was to create an report in nprinting with different value coming from current year, last year , quarter and YTD.

For now in Nprinting i am using formula for each time period above to calculate a+b etc.....

a+b current year = sum({<Formula={a+b},Year={2016}>}Sales)

a+b Last year = sum({<Formula={a+b},Year={2015}>}Sales)

a+b Quarter year = sum({<Formula={a+b},Quarter={"Q3"}Sales)

The difference from formula above is only on the Year={2016},Year={2016},Quarter={"Q3"}

Can i just write sum({<Formula={a+b}>}Sales) once and then apply period filter to the column?
because if there is more than 50 row it is time consuming to write the formula one by one

Thanks for your attention

Re: Different Filter for each excel column in NPrinting

Thu, 15 Sep 2016 15:09:42 GMT

Hi Velaga

Is there another way than writing the expression one by one?, currently i'm doing like that

Im trying to use filter in nprinting but it appears that the filter is affected all of the column

Thanks

Re: Different Filter for each excel column in NPrinting

neelamsaroha157 — Thu, 15 Sep 2016 17:27:27 GMT

You can create a variable as sum({<Formula={a+b},Year={$(1)}>}Sales)

and use this variable in your expression and pass value for year as your parameter.

May be you'll have to create two variables one for the Year parameter for column 1 & 2 and other variable for Quarter column.

Hope this helps...