Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I'm fairly new to QlikView, and I'm now faced with a challenge of creating of report that needs to show details about reports that are on Access Point.
In Qlikview Managment Console, when I look in the task details i see a valid number of user that can access the report,
but when I make an application it shows a different information about number of user.
Here is the code,
any help will be appreciated
SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='#.##0,00 €;-#.##0,00 €';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD.MM.YYYY';
SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';
SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';
SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So';
// Start of [Task_0a2f3b46-e956-4d92-bc5c-fe305923c400.xml] LOAD statements
AddRecipient:
LOAD
filebasename() as %KeyTask,
ObjectType,
ID as UserApp
//%Key_DistributeTask_3BD6A6DF582C1659 // Key to parent table: DistributeTask
FROM [\\10.145.73.78\Qlikview\QlikView_Server_QV_Server\REPO\Tasks\*.xml] (XmlSimple, Table is [DistributeTask/Resources/Resource/AddRecipient]);
DistributeTask:
LOAD
filebasename() as %KeyTask,
Name,
Enabled,
[AbendTriggers/RunTimeTrigger/MaximumMinutes] as MaximumMinutes,
[Resources/Resource/AddRecipient/ID] as [AddRecipient/ID],
[SourceDocument/FileName] as FileName,
[TaskCategories/TaskCategory/Name] as [TaskCategory/Name],
[StartTriggers/ScheduleTrigger/RepeatEvery] as RepeatEvery,
[StartTriggers/ScheduleTrigger/HourStart] as HourStart
FROM [\\10.145.73.78\Qlikview\QlikView_Server_QV_Server\REPO\Tasks\*.xml] (XmlSimple, Table is [DistributeTask]);
// End of [Task_0a2f3b46-e956-4d92-bc5c-fe305923c400.xml] LOAD statements
Hi,
That is because QlikView store UTC time.
In order to proper utilize QlikView logs and generate a report like who accesses application and all.
why don't you try the below ready made application.
http://community.qlik.com/docs/DOC-4307
Regards
ASHFAQ
Hello Mohammed,
this is not exactly what I was looking for. I need correct data from logs, but the data is not actual.
That is the problem.
Thank you for input, but do you have idea what should I do?
Hi,
Did you look at the link to application in my post?
It covers lot of things.
Regards
ASHFAQ