Data according to dates in qlikview

[capriconuser]

I want latest data on sheet .. i tried this on chart and through this i got latest data 

count({<LMax_Date={'$(vLMaxDate)'},[No]-={'NA'}>} distinct [No])

in VLMaxDate i did this 

=Max(LMax_Date)

now i call this variable on input box just for checking latest date is displayed or not.. in my folder latest sheet for the month of Aug 2021

so in LMaxDate date is 31-08-2021

now here i want when user the change the date then according to date data will also change

i created this varaible L_Date and call date column 

=LMax_Date

and drag in list box and also in input box but both objects are empty . 

where as these dates are in LMaxDate column 

any help 

[MayilVahanan]

Hi

Try like below

You can see all the laptop_max_date in the dropdown menu of the variable .

thanks

[NageshSG]

Hi @MayilVahanan 

Good suggestion!

Few down sides though -

1. The user is not able to change the expression outcome in the chart using this variable.

  Workaround: use a Logical Island date column as suggested earlier or use a more complex expression in the measure to take user triggered change in the LDate if it is not same as LMaxDate!

2. The variable will always display one 'date value' only (either user selected or default min date).

3. The user can  change the default from the drop down list.  Variable is primarily used as an info only.

Regards.

[MayilVahanan]

Hi Nagesh,

Yes, but Its depends on the requirements need to change the option.