Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

List of sales Product

Hey evrybody, I have a 'small' problem, so I have the follow script

Sales:

LOAD * INLINE [

    code, OrderDate,total

    1, 16.07.2014,10

    2, 16.07.2014,52

    3, 16.07.2014,588

    1, 17.07.2014,855

     3, 17.07.2014,452

     4, 17.07.2014,542      

];

code:

NoConcatenate LOAD

Distinct

code 

Resident Sales;

Left Join(code)

LOAD

code,

OrderDate,

total

Resident Sales;

DROP Table Sales;

EXIT Script;

I would like to get 2 lists:

list of items that were sold the 16.07.2014  and were not sold the 17.07.2014
code
2

list of items that were sold the 17.07.2014  and were not sold the 16.07.2014
Code
4

Please could sombody helps me ? 😞

thanks

Best

Army

Labels (2)
1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

For List 1:

Dimension: code

Expression: =Only({<OrderDate={'16.07.2014'}, code = E({1<OrderDate={'17.07.2014'}>})>} code)

For List 2:

Dimension: code

Expression: =Only({<OrderDate={'17.07.2014'}, code = E({1<OrderDate={'16.07.2014'}>})>} code)

Hope this helps you.

Regards,

jagan.

View solution in original post

3 Replies
jer_2011
Creator II
Creator II

Hello,

I let this solution, I hope you serve

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

For List 1:

Dimension: code

Expression: =Only({<OrderDate={'16.07.2014'}, code = E({1<OrderDate={'17.07.2014'}>})>} code)

For List 2:

Dimension: code

Expression: =Only({<OrderDate={'17.07.2014'}, code = E({1<OrderDate={'16.07.2014'}>})>} code)

Hope this helps you.

Regards,

jagan.

Not applicable
Author

Hey Jagan

just wan to say Thanks

Best
Armand