topic Re: make a left join (not from script) in QlikView

make a left join (not from script)

ali_hijazi — Thu, 26 May 2011 07:21:49 GMT

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

make a left join (not from script)

Thu, 26 May 2011 07:26:25 GMT

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

make a left join (not from script)

ali_hijazi — Thu, 26 May 2011 07:38:49 GMT

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

Re: make a left join (not from script)

Thu, 26 May 2011 07:59:08 GMT

Hi,

here a fast example.

Andrea

make a left join (not from script)

ali_hijazi — Thu, 26 May 2011 12:00:07 GMT

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

make a left join (not from script)

Thu, 16 Feb 2012 10:59:53 GMT

Hi,

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