Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Different Filter for each excel column in NPrinting

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

FormulaCurrent yearLast YearQuarter 3YTD
a+b10232155
a+b+c50808070
a+d+e60706050
a+b+c+d+e100150150120

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





5 Replies
Highlighted
Specialist II
Specialist II

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

Highlighted
Creator III
Creator III

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

Highlighted
Not applicable

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

Highlighted
Not applicable

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

Highlighted
Specialist II
Specialist II

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...