Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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
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...