topic Intersection & Exclusion : Need help in an expression in QlikView

Intersection & Exclusion : Need help in an expression

marieclaire — Sat, 16 Nov 2024 01:19:59 GMT

Hi the community !

Anybody could help me in resolving that issue ?

The List 1 'BEFORE' gives all the pages seen before an Event (payment).
The List 2 'AFTER' gives all the pages seen after the last Event.

In a straight table, with the dimension 'Page', i can see the 2 groups of pages, using those 2 expressions that work :

Expression 1 = 'BEFORE'
count( {< [@Visit ID]={"=min(p.Content) < min(p.Event)"} >} DISTINCT [ID-content])

Expression 2 = 'AFTER'
count( {< [@Visit ID]={"=min(p.Content) > max(p.Event)"} >} DISTINCT [ID-content])

I need to identify the pages of Expression 2 that are not seen by the Expression 1.

Do you think i can do it in a expression ?
I do not manage to do it.

Thank you for your help !

Re: Intersection & Exclusion : Need help in an expression

sunny_talwar — Thu, 06 Feb 2020 17:45:30 GMT

Would you be able to show this with means of an example as to what you want to get?

Re: Intersection & Exclusion : Need help in an expression

Brett_Bleess — Thu, 05 Mar 2020 16:38:31 GMT

If you managed to sort things out, please consider closing the thread by posting what you did and then use the Accept as Solution button on that post to mark that as the solution. If you still require help, please provide further information per Sunny's post. The best I can offer otherwise is the following link you can use to search the Design Blog area to see if you can find something that may help there.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett