Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

log file visualization

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!

1 Solution

Accepted Solutions
maxgro
MVP
MVP

maybe this? count date for action=make

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

View solution in original post

6 Replies
Not applicable
Author

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

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

maxgro
MVP
MVP

maybe this? count date for action=make

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

View solution in original post

Not applicable
Author

Great answer! Massimo, thank you so much!

Not applicable
Author

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

jsaradhi
Specialist
Specialist

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
MVP
MVP

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