Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with a date and tank level, the tank level is measured every hour. When I have the month of may selected (as an example). I only want the level for the last hour in the fiscal month. What would I do?
Date | Tank 1 | Tank 2 | Tank 3 | Tank 4 |
---|---|---|---|---|
2018-05-27 | 28 | 47 | 27 | 29 |
2018-05-27 | 20 | 39 | 72 | 50 |
2018-05-27 | 102 | 19 | 40 | 10 |
2018-05-27 | 29 | 29 | 102 | 29 |
2018-05-27 | 19 | 47 | 28 | 72 |
Hi,
Can you share sample data for same?
I cannot because of confidentiality issues, and I would love to solve these issues in the office but I am the only one in the office with any understanding of qlik.
If you have FiscalMonth as Field then You can use Max(Fiscal_Month)