log file visualization

[#1]

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!

[#2]

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

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

[maxgro · Accepted solution]

maybe this? count date for action=make

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

[#4]

Great answer! Massimo, thank you so much!

[#5]

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

[Anonymous]

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.

[maxgro]

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