How do I convert a week-year string to dual

QlikMo — Mon, 03 Oct 2022 14:54:42 GMT

I am storing weekly QVD snapshots using the function WeekName(date) as the filename (e.g. 2022/40). When I load that file back in I use the filename as a snapshot WeekYear field to differentiate it from other snapshots.

The issue I have is that the WeekYear field has now lost the dual functionality and is treated as a string. This is only an issue for me when sorting charts - Sort by numeric value is not working, however A-Z sort does (but I don't want to rely on this).

How can I get the dual functionality back for a WeekName() formatted string?

LOAD '$(a)' as WeekYear ... from [C:\$(a).qvd] (qvd)

Thanks

Re: How do I convert a week-year string to dual

rubenmarin — Mon, 03 Oct 2022 15:11:21 GMT

Hi, you can create a Dual value using the Dual() function where you can assign a number to each string, in this case it could be:

Dual(WeekName(date),(Year(date)*100)+Week(date))

topic Re: How do I convert a week-year string to dual in QlikView

How do I convert a week-year string to dual

Re: How do I convert a week-year string to dual