topic Re: Load data from multiple qvds - but print only latest value in set expression in QlikView

Load data from multiple qvds - but print only latest value in set expression

sayadutt — Sat, 16 Nov 2024 02:38:46 GMT

Hi,

I am creating a new qvd everyday and loading the same in my qvw file using wild character.

Now in the chart Set expression, I need the count of an item from the last qvd file only.

When I use count(id), it gives me the count from ALL qvds, but I am only interested in LAST (latest) count.

Can you please help me.

Thanks

Re: Load data from multiple qvds - but print only latest value in set expression

Vegar — Fri, 23 Aug 2019 18:40:09 GMT

Assuming you have a date Field (or other numeric field) that increases per source file, you can use this for your set analysis.

=Count({< DateField = {"=$(=max(DateField))"}>}id)

Re: Load data from multiple qvds - but print only latest value in set expression

neelamsaroha157 — Fri, 23 Aug 2019 19:04:36 GMT

What you can try is you can create a column that would differentiate you each qvd and use that field in your set analysis. For example Filename() as columnName your column and in your expression you can use {<ColumnName = {'value here'}>}.

Re: Load data from multiple qvds - but print only latest value in set expression

sayadutt — Fri, 23 Aug 2019 19:17:29 GMT

Hi Vegar,

Yes, I have a unique Date field. However when I use your expression below, I don't see any change.

It is still showing count of ALL, instead of latest.

Count({< EntryDate = {"=$(=max(EntryDate))"}>}id)

Re: Load data from multiple qvds - but print only latest value in set expression

Vegar — Fri, 23 Aug 2019 20:05:12 GMT

Just to make sure. You are adjusting the expression to your date field name? (The EntryDate and id field)

If it still does not work, try this:

Count({< EntryDate = {'$(=maxstring(EntryDate))'}>}id)

Re: Load data from multiple qvds - but print only latest value in set expression

sayadutt — Fri, 23 Aug 2019 20:12:05 GMT

Hi Vegar,

I have a new field say TOTAL, where I need to show the COUNT(Ids) from the latest qvds.

I tried with maxstring as well, but no luck.

When I create a listbox for for EntryDate and select some dates from there, then the above table works.

I am looking for something which will automatically show the latest value and users don't have to click the latest date from Listbox.