Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to flag rows in script based on events?

So i got this issue, and i simply cannot figure out how to manage this.

As in my previous post i want to find the row where there has been a BUY event when there also have been an Itemclick event within the same session.

Notice: It should be in the script and not in a expression (i think its too heavy)

RowIDSessionIDPriceEventFlag
111420itemclick0
211450visit0
311490Buy1
411427Buy1
516826Buy0
616856Buy0

Hope you can help

Thanks in advance

22 Replies
Not applicable

Thomas,

I create a table called TempCookie where I merge cookie and product, so that I get a list I can test (always with exists() function.

I did not catch if the itemclick should occur in the same session or not. You said whatever session but the flag in the file indicated the inverse (the item click should have done in another session).

=> I have made both (see the field name and comments)

Fabrice

Not applicable

Thank you! Ive tried something similar but this works great! appreciate it a lot - Hope you didnt have to work to hard

Not applicable

Hi Fabrice!

Do you remember this thread?

I have a question regarding this. What if i want to make sure, that the itemclick always has been first (So there cannot be registered a buy if the itemclick is later than the buy )

Like this CORRECT

Header 1Header 1Header 2Header 3Header 4Header 5
DateCookieSessionItemIDEventtypeFlag
2014-04-201a100Itemclick
2014-04-211a100Buy1

This is WRONG:

Header 1Header 1Header 2Header 3Header 4Header 5
DateCookiesessionItemideventtypeflag
2014-04-201a100buy1
2014-04-211a100itemclick

So the itemclick must always be before the buy.