Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
swarnendu
Creator II
Creator II

Pick value only last date of the month

Hi guys,

I have a table and I want to create a table and extract only the last day of month for every month,

i already used firstsorted value its also take perfect data .

but i have facing a problem ,

which item have only one date (01/07/2017)  if i select month sep then how we populate the data in month of sep which have only one transaction date on july.

If any one have any solution the please suggest me.

nnnnn.jpg

5 Replies
sunny_talwar

Would you be able to share your app with us and elaborate on what you are looking to get and in which chart?

swarnendu
Creator II
Creator II
Author

dateiTEM IDSTOCK
24/09/2017101160
26/09/2017101120
31/09/2017101120
10/09/2017102250
21/09/2017102270
31/09/2017102270
07/09/2017103310
31/09/2017103310
18/09/2017104105
31/09/2017104105
01/07/2017105280
31/09/2017105280
01/08/2017106320
31/09/2017106320

PLEASE SEE MY highlights area so you can understand my problem i want only highlighted value.

sunny_talwar

So what you have highlighted above is something you have already figured out, right? You are looking for a way to show an item with single date in July to show in September? Can you give me the MasterCode1 for this item?

swarnendu
Creator II
Creator II
Author

MasterCode1    3102

mastercode2     7466

sunny_talwar

So in this case since you don't have value in September, you would want to show Aug 2017 value? I think to solve this, you will need to generate missing data here... don't see getting this done without generating missing data.

For the very least, we should have at least have a single entry for September for the above selection so that we can at least see the Month of Sept 2017 active for selection.

Generating Missing Data In QlikView