topic Re: Multiple transaction date in QlikView

Multiple transaction date

renjithpl — Tue, 19 Sep 2017 19:57:45 GMT

Hi All,

I have a table with 10 million records, but i have three diff dates (Created_Date, Closed_Date, Win_Date).

I created a Master calendar where I have "Date_Field". (concatenation of all the three dates)

I want to show the transaction happened for all three dates in different charts.

I have split the 10 million table into three different table with Created_Date, Closed_Date and Win_Date.

My application is heavy now. with 30 million records.

Is there another approach where i can get this without splitting.

THanks

Renjith

Anil_Babu_Samineni — Wed, 20 Sep 2017 03:05:26 GMT

How is your split code? I am thinking about creating FLAG to use different scenario. Have you done the same?

Load Date1 as DateField, 'Date1' as Flag, .....;

Concatenate

Load Date2 as DateField, 'Date2' as Flag, .....;

Concatenate

Load Date3 as DateField, 'Date3' as Flag, .....;

In UI, you can use any one of Flag as per business need like

Sum({<Flag = {'Date3'}>} Measure) // This returns only sums the Measure where Date3 field has data points..

renjithpl — Wed, 20 Sep 2017 06:52:46 GMT

I have tried this, but will you connect from this bridge table to the Transaction table with Three dates.

Which Key ? I have to have a combination key in my transaction table too.