I have table consist more than 1 lakh data, i want to create chart for every scheme with the latest date of data. i have imported whole table into qlikview.
My understanding is that you should display only the latest date's data in the chart.
If my understanding is correct, you can do this using set analysis in the calculation expression like this (Sum({<DateField={$(=Max(DateField))}>} Fact ))
The fact value for the latest date will be calculated in the above expression
