Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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

Re: List of sales Product

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.

3 Replies
jer_2011
Contributor II

Re: List of sales Product

Hello,

I let this solution, I hope you serve

MVP
MVP

Re: List of sales Product

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

Re: List of sales Product

Hey Jagan

just wan to say Thanks

Best
Armand

Community Browser