
Re: Different Filter for each excel column in NPrinting
neelam sehrawat Sep 15, 2016 10:32 AM (in response to Arviddree Sanjaya)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
Arviddree Sanjaya Sep 15, 2016 11:08 AM (in response to neelam sehrawat)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 oneThanks for your attention

Re: Different Filter for each excel column in NPrinting
neelam sehrawat Sep 15, 2016 1:27 PM (in response to Arviddree Sanjaya)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...



Re: Different Filter for each excel column in NPrinting
Praveena Velagapudi Sep 15, 2016 10:51 AM (in response to Arviddree Sanjaya)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
Arviddree Sanjaya Sep 15, 2016 11:09 AM (in response to Praveena Velagapudi)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
