Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to get amount in last 6 months and last 18 months

i am stuck here for calculating data

From last 24 months have to check data with first 6 months and

for last 6 months based on a date column in format(YYYYMMDD) to first 18 months.

Can you anyone please suggest.

51 Replies
YoussefBelloum
Champion
Champion

here it is,

you have the data, the expression, the output, enjoy

Anonymous
Not applicable
Author

where is output

YoussefBelloum
Champion
Champion

Can't you see this on the app I gave you ???

output.png

Anonymous
Not applicable
Author

i did not see app attached here

YoussefBelloum
Champion
Champion

here it is

screeeen.png

here it is attached one more time

Anonymous
Not applicable
Author

In the app you sent have only sample date and data  which i provided. No Expression is there for 6 months and 18 months data. Can you please add that in app and resend please

Anonymous
Not applicable
Author

yeah, i see it now.

But In the app you sent have only sample date and data  which i provided. No Expression is there for 6 months and 18 months data. Can you please add that in app and resend please

Anonymous
Not applicable
Author

and also in screenshot, you provided 18 months as last 18 months but my request to get first 18 months in last 24 months

YoussefBelloum
Champion
Champion

OK, open the app, take screen shots of what you can see on it (Tables, and expressions on the tables).

If you don't know how to attach screen shots here, here is my email: youssefbelloumtn@gmail.com

JUST SHOW ME WHAT YOU CAN SEE ON THE APP I SEND TO YOU

Thank you

Anonymous
Not applicable
Author

Not able to attach screenshot now, but in app we have only 2 columns date and data

where i add date and data into sheet it gave as

date                                                 data

20160301                                      100

20160401                                       400

20160501                                       500

20160601

20160701

20160801

20160901

20161001

20161101

20161201

20170101

20170201

20170301

20170401

20170501

20170601

20170701

20170801

20170901

20171001

20171101

20171201

20180101

20180201

but i need an expression for last 6 months and first 18 moths in last 24 months. can  you help here please