Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gino2780
Contributor

comparison tables (stock/inflow/outflow)

Hello,

on a monthly basis we get data of our stock properties with id and several further information (columns).

I'd like to monitor or rather identify stock and new and/or lost properties (inflow/outflow) for each month in the dataeditor by generating scriptwise a filter variable based on the (property)id, so that i can use that filter to identify stock, inflow and outflow properties on the dahsboards.

In other words, i'd like to ask my data the question:

Which properties in table october (timestamp1) are equal to the table november (timestamp2)?

Which properties in table october (timestamp1) are unequal (inflow/outflow) to table november (timestamp2)?

simplified data structure:

table october

id | name | etc.1 | etc.2 |

1  |

2  |

3  | 

4  |

 

table november

id | name | etc.1 | etc.2 |

1  |

2  |

3  |

5  |


green = stock

blue   = new property (inflow)


Thanks in advance

gino2780

1 Solution

Accepted Solutions
vinieme12
Esteemed Contributor II

Re: comparison tables (stock/inflow/outflow)

There are two ways to track any new additions, Use the logic the suits you best Attached sample shows both.

For lost properties  reverse the logic or else this would be better done in chart,

let me know if you need help

4 Replies
ganeshsvm
Contributor

Re: comparison tables (stock/inflow/outflow)

Can you post a sample data and elaborate on the required result or Picturize you requirement in an image.

Regards,

GSVM

vinieme12
Esteemed Contributor II

Re: comparison tables (stock/inflow/outflow)

There are two ways to track any new additions, Use the logic the suits you best Attached sample shows both.

For lost properties  reverse the logic or else this would be better done in chart,

let me know if you need help

gino2780
Contributor

Re: comparison tables (stock/inflow/outflow)

Vineeth, thank you. That looks quite well.

I could reproduce your data and will apply it to my data, which are way more complex.

If i'll have any further questions with my original data, i'll ask here again.

vinieme12
Esteemed Contributor II

Re: comparison tables (stock/inflow/outflow)

Sure