topic Re: Get data from cell value in QlikView

Get data from cell value

Jogi — Sat, 16 Nov 2024 02:09:00 GMT

Hi guys,

I have a table with qvd path, and does anybody know how successfully get from cell month and year:

C:\QlikResource\BI\Application\QVD\Data\2016-10 Products.qvd

Expected result:

Year	Month
2016	10

Re: Get data from cell value

Arthur_Fong — Wed, 23 Oct 2019 08:13:27 GMT

Try this:

load *,SubField(FileName(),'-',1) as FileYear,mid(FileName(),index(FileName(),'-',1)+1,2)as FileMonth from [2016-10 Products.qvd](qvd);

Re: Get data from cell value

Brett_Bleess — Thu, 31 Oct 2019 17:52:10 GMT

Jogi, did Arthur's post get you what you needed? If so, be sure to give him credit by using the Accept as Solution button on his post, which will also let others know the recommendation did work for the use case too. If you are still working on things, please leave an update.

Regards,
Brett