Qlik Community

Qlik Support Discussions

Discussion Board for collaboration related to Qlik Support.

Highlighted
sangeeth8787
New Contributor

Month First data and Last Date Value for snapshot fact table

Hi,

I have two filter one with date and month,  and a snapshot fact table, If user select a particular date, then I want to show the balance of starting and end of the day values, If I choose any particular date in filter criteria, the correct values are showing up, but when I choose month filter, the values are summing up. But the required output is like

 

Month                 Date                       OpeningBalance                      Closing Balance

     Jan               1st Jan                           15.5                                                      26.5

    Jan               2ndJan                           26.5                                                      55.5

.

.

.

Jan                 31st                                  105                                                          215

 

If a user choose filter Month then desired output is 1st Data of January Opening Balance (15.5)  and Last Date of January which is 31st Day Closing Balance (215)

If a user choose any particular date only, like Jan 2nd the opening balance 26.5 and closing balance 55.5.

Could you please help with this query. 

 

Many Thanks

 

Sangeeth

Community Browser