Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
lavielme
Creator
Creator

SET EXP

Hay All

What Can I do If I need to calculate the last date for each company

depend on month selection

lats say

if i have

    Company, Date, Stoc

    X, 30/05/2016, 10

    X,01/06/2016,15

     X,05/06/2016,20

    Y, 31/05/2016, 20

     Y,25/05/2016,30

    Z, 31/05/2016, 30

    X, 30/04/2016, 40

    Y, 01/05/2016, 10

    Z, 02/05/2016, 30

    X, 28/03/2016, 40

    Y, 31/03/2016, 50

    Z, 31/03/2016, 10

    X, 27/03/2016, 20

    Y, 31/03/2016, 30

    Z, 01/04/2016, 40



AND I Select jun


i will see


Company    Stoc

X                    20



AND If i will select may i will see


Company    Stoc

X                    10

Y                    20

Z                    30



Best Regards

Lavi

1 Reply
oknotsen
Master III
Master III

Do not start the same topic twice.

calculate the last date for each company

Locked.

May you live in interesting times!