make a left join (not from script)

[ali_hijazi]

Hello

I have a large table of transactions (millions of records) for clients

I want on a specific date get all  clients who didn't make an order or transaction i.e those clients who don't have a record in the transactions table on that date

I made a left join from clients table to transactions but this is taking a lot of time and the CPU usage reached the 100%

is there any other way to make a left join to get null values of transactions ids for clients not making orders on the selected date?

the information is to be displayed on a straigt table

[#2]

Hi,

if I correctly understand what you need I will do the selection of all records coming from the fact table, go to the list of customers and selectd the excluded values. These are the customers that haven't rcords in the fact table.

You can make this by a macro.

Andrea

[ali_hijazi]

may you please send me a small example on macros as I'm new to qlikview?

[#4]

Hi,

here a fast example.

Andrea

[ali_hijazi]

Thank you this was helpful

but what I really want to display on a list box or table all list of customers with the respective quantities and those excluded with zero quantity

help is appreciated

[#6]

Hi,

in the object properties you can select the Presentation tab and you have to suppress the flag in 'suppress zero values' property.