topic Make one date appear in a table in QlikView

Make one date appear in a table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Make one date appear in a table

md_qlikview — Tue, 17 Jul 2018 13:05:57 GMT

Hi,

Can you share sample data for same?

Re: Make one date appear in a table

Anonymous — Tue, 17 Jul 2018 13:09:22 GMT

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.

Re: Make one date appear in a table

Anil_Babu_Samineni — Tue, 17 Jul 2018 13:56:46 GMT

If you have FiscalMonth as Field then You can use Max(Fiscal_Month)