Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

Data according to dates in qlikview

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 . 

capriconuser_0-1628884558544.png

 

where as these dates are in LMaxDate column 

capriconuser_2-1628884832822.png

 

any help 

 

12 Replies
stevejoyce
Specialist II
Specialist II

How did you define L_Date?

MayilVahanan

HI

VLMaxDate  <-- you are storing the max value of LMax_Date in the variable , not selecting the max value in the field.

So if you assign the field value in the variable L_Date, Qlik doesn't recognize, which values need to display in the variable, that;s the reason, it display blank value.

You can assign the Max(LMax_Date) in the variable L_Date.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
capriconuser
Creator
Creator
Author

@stevejoyce this is varaible.. in this i called column

capriconuser
Creator
Creator
Author

@MayilVahanan but i want all dates in L_Date .. and when user select the date the according to the date data should be change 

MayilVahanan

HI

In that case, try with calendar object.

And store the date selection in the variable based on ur requirement.

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
capriconuser
Creator
Creator
Author

is list box work ? will u please share any sample

MayilVahanan

Hi 

Please provide the sample data and expected output. Will send it back.

thanks

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
capriconuser
Creator
Creator
Author

check files please  @MayilVahanan 

NageshSG
Partner - Contributor III
Partner - Contributor III

Hi,

Variable will not store List of Values from a field unless it is aggregated resulting in one value or only value is possible.

You can use a logical date island in a List Box for user to select. If nothing is selected then the variable vLMaxDate will store Max(Laptop_Max_Date) else Max(Logical_LDate). 

see below:

1. Script - create logical island as under:

Logical_LDate:
Load distinct
Laptop_Max_Date as Logical_LDate
Resident Laptop_Date_Table;

2. Change the variable expr as under:

vLMaxDate =if(GetSelectedCount(Logical_LDate)>=1, Date(Max(Logical_LDate)), Date(Max(Laptop_Max_Date)))

3. Create List Box for user to optionally select the LDate from: Logical_Date

Hope the above helps.