Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

calendar week / year in graphic and tabel

Hi,

I am trying to create a grphic that can be switched to a table in which I am using the date Format WW/YYYY as dimension.

I tried week(myDate) & ' / ' & year(myDate) as dimension but since it is a string the diagram is not working and it can not be sorted correctly in the table.

I tried to just use the date and present it as week of year in the diagram, but than the table showes the dates not the calendar weeks.

Can anyone help? I would be happy about some ideas.


Thanks in advance

Rasmus

Tags (3)
1 Solution

Accepted Solutions
Not applicable

Re: calendar week / year in graphic and tabel

You have to sort by expression and your sorting exsression should be "=min(myDate)"

4 Replies
Not applicable

Re: calendar week / year in graphic and tabel

You have to sort by expression and your sorting exsression should be "=min(myDate)"

dagomezl
Contributor III

Re: calendar week / year in graphic and tabel

you try use

DATE(POST_DATE,'WW/YYYY') as Dimension

in the configuration Sorted by numeric

Highlighted
Not applicable

Re: calendar week / year in graphic and tabel

Hi Diego,

yes I tried that, it delivers values only from 00/YYYY to 06/YYYY and I don't get what the numbers are actually standing for.

Thanks anyway

Rasmus

Not applicable

Re: calendar week / year in graphic and tabel

Hi Märt,

that works

Thanks a lot

Rasmus

Community Browser