topic Re: Data according to dates in qlikview in Integration, Extension & APIs

Data according to dates in qlikview

capriconuser — Fri, 13 Aug 2021 20:01:06 GMT

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

Re: Data according to dates in qlikview

stevejoyce — Fri, 13 Aug 2021 20:22:07 GMT

How did you define L_Date?

Re: Data according to dates in qlikview

MayilVahanan — Sat, 14 Aug 2021 06:09:09 GMT

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.

Re: Data according to dates in qlikview

capriconuser — Mon, 16 Aug 2021 06:21:28 GMT

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

Re: Data according to dates in qlikview

capriconuser — Mon, 16 Aug 2021 06:22:41 GMT

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

Re: Data according to dates in qlikview

MayilVahanan — Mon, 16 Aug 2021 07:30:13 GMT

In that case, try with calendar object.

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

Re: Data according to dates in qlikview

capriconuser — Mon, 16 Aug 2021 07:34:52 GMT

is list box work ? will u please share any sample

Re: Data according to dates in qlikview

MayilVahanan — Mon, 16 Aug 2021 07:37:44 GMT

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

thanks

Re: Data according to dates in qlikview

capriconuser — Mon, 16 Aug 2021 12:41:15 GMT

check files please @MayilVahanan

Re: Data according to dates in qlikview

NageshSG — Mon, 16 Aug 2021 13:43:29 GMT

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.

Re: Data according to dates in qlikview

MayilVahanan — Tue, 17 Aug 2021 02:48:01 GMT

Try like below

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

thanks

Re: Data according to dates in qlikview

NageshSG — Tue, 17 Aug 2021 04:09:04 GMT

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.

Re: Data according to dates in qlikview

MayilVahanan — Tue, 17 Aug 2021 04:25:39 GMT

Hi Nagesh,

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