topic Re: log file visualization in QlikView

log file visualization

Wed, 16 Jul 2014 16:15:11 GMT

Hey guys,

If I have a log file with action and date, I would like to ask you whether there is a way to just track one of the action values, say "make", count it and visualize it on a line chart with the date dimension?

Many Thanks!

Re: log file visualization

Wed, 16 Jul 2014 16:25:39 GMT

or let's say is there any mistakes with this expression:

=count({<date = {"=only(action)='make'"}>} date)

Re: log file visualization

maxgro — Wed, 16 Jul 2014 16:40:00 GMT

maybe this? count date for action=make

count({$ <action={make}>} date)

Re: log file visualization

Wed, 16 Jul 2014 17:17:28 GMT

Great answer! Massimo, thank you so much!

Re: log file visualization

Wed, 16 Jul 2014 19:18:37 GMT

Massimo, what if I would like to limit another value of another column, say field value "manufacturing" from column department besides "make" from action?

Re: log file visualization

Anonymous — Wed, 16 Jul 2014 19:20:38 GMT

try this...count({$ <action={make}, department={manufacturing}>} date)

i'm guessing you need single quotes for make and manufacturing in the above formula...but if Massimo's formula worked without quotes, then the above formula may work too.

Re: log file visualization

maxgro — Thu, 17 Jul 2014 07:08:34 GMT

you already get the answer

for set analysis you can find examples, help,etc,.... in

- qlikview online help

- and in this very good doc Sets Analysis: syntaxes, exemples