Welcome to Qlik Community

Hi Team, 

               I am new to NPrinting and i am facing the issue on User name in NPrinting Footer. 

Tasks : Need to show QVuser name in NPrinting. 

Please refer below my Steps(but i am not getting what i am expected)

1. Created One variable in Qlikview (vPrepared By = 'Prepared By: ' & Subfield(OSUser(),'\',2) 

2. Value is showing as Prepared By: Sakthivel. Selvaraja 

3. Taking this variable in Nprinting Variable. 

4. If I Use this variable in Qlik Nprinting it is showing as NPAdmin(which is Nprinting Admin User)

5. But what my expectation is shown as the same above which is Prepared By: Sakthivel.Selvaraja. 

Will anyone help me to resolve this . It is very urgent

Thanks and Regards, 

Sakthivel.S

Good day 

I am using NPrinting Feb V21.0.0.0 with Qlik Sense 2020 Patch 2.

When I create a NPrinting Power point report I get this error when I try and add a image in using Template editor: Exception to HRESULT: 0x80048240 (In screenshot below).

I am able to do this when creating reports in all other formats, but I cannot drag and drop the image into Excel or Word within template Editor.

Your assistance will be highly appreciated.

Kind regards,

Justin 

Hello Qlik Enthusiasts , 

I want to have a little calendar where i can choose a particular date for example, 02-04-2022 and then get all the records which would be expired until this date. The date is as follows . 

Student , Document, Expiration Date, Document Status 

101, Doc1, 12-03-2021, Expired 

102, Doc2 , 12-09-2022, Valid

103, Doc3, 12-11-2021, Valid 

104, Doc4, 31-12-2021, Valid

for now i am calculating status if the expiry date is less than today then its expired. But i want to have a calendar where i can choose a particular date and get all the expired certifcates until that particular date. For example,if i select 31-12-2021 then i would like to get the following output . 

Student , Document, Expiration Date, Document Status 

101, Doc1, 12-03-2021, Expired 

102, Doc2 , 12-09-2022, Valid

103, Doc3, 12-11-2021, Expired

104, Doc4, 31-12-2021, Expired

Please help me solve this , Thank you for your valuable time in Advance. 

Hello

Could someone please describe what happened in this dual expression?

=Dual(Num(Sum(Quantity), '#,###.') & Chr(10) & Num(Sum(Quantity)/Sum(TOTAL <Market> Quantity), '##.##%'), Sum(Quantity))

As far as I know, Dual creates both text and numeric value out of single field/variable, and structure looks like DUAL(text, numeric), however in this expression there are three sections:

(Num(Sum(Quantity), '#,###.') - I guess its going to be first value, integer stored as a text

Num(Sum(Quantity)/Sum(TOTAL <Market> Quantity), '##.##%') - this is going to be second value, numeric, percentage

Sum(Quantity)) - I am completely blunt with this one.  This refers to let Y axis be sum of quantity? Just a blind guess.. and without this, the expression has an error. How one could know, it is necessary, can you share knowledge behind this?

Thank you in advance

Hello Everyone,

I am using below formulae in my calculation :-

if(GetSelectedCount([User.Divison Name])>0,((Sum({<INPUT_DATE = {">=$(=Date(MonthStart(Max([INPUT_DATE]))))<=$(=Date(Max([INPUT_DATE])))"}>} NB_HOURS)

/

(only({<INPUT_DATE = {">=$(=Date(MonthStart(Max([INPUT_DATE]))))<=$(=Date(Max([INPUT_DATE])))"}>}Real_ActualDays)*8)) /count([Person Name])),

if(
GetSelectedCount([User.Department Name])>0,(Sum({<INPUT_DATE = {">=$(=Date(MonthStart(Max([INPUT_DATE]))))<=$(=Date(Max([INPUT_DATE])))"}>} NB_HOURS)

/

(only({<INPUT_DATE = {">=$(=Date(MonthStart(Max([INPUT_DATE]))))<=$(=Date(Max([INPUT_DATE])))"}>}Real_ActualDays)*8)),

(Sum({<INPUT_DATE = {">=$(=Date(MonthStart(Max([INPUT_DATE]))))<=$(=Date(Max([INPUT_DATE])))"}>} NB_HOURS)

/

(only({<INPUT_DATE = {">=$(=Date(MonthStart(Max([INPUT_DATE]))))<=$(=Date(Max([INPUT_DATE])))"}>}Real_ActualDays)*8))/count(distinct [User.Department Name])

)) // & '%'

Now inside the selection, i want to add colors on the basis of condition in %input completion column.

If % input completion >=100, green(), red().

I am unable to implement this condition inside this expression. The way to do it is add the color expression in background color option , however, i am unable to do it.

Can anyone please help ?

Thanks in advance