Chart expressions

Pavithra_2198 — Mon, 13 Sep 2021 06:35:31 GMT

Hi,

I want to sort the date field in x-axis for my bar chart in chronological order (Jan, Feb, Mar....).

Should be represented as : 2021-Sep-13_A(Mon), 2021-Oct-21_B(Thu)

I tried doing like this in expression :

year(date(date#(left(date,18),'YYYYMMDD'))) & '-' & month((date(date#(left(date,18),'YYYYMMDD'))) & '-' & date((date(date#(left(date,18),'YYYYMMDD'))) & '_' & ('A' or 'B') & '(' & day((date(date#(left(date,18),'YYYYMMDD'))) & ')'

how could I solve this?

Re: Chart expressions

sunny_talwar — Mon, 13 Sep 2021 13:26:33 GMT

Use Dual function

Dual( //Text Part Date(Date#(Left(date, 18),'YYYYMMDD'), 'YYYY-MMM-DD') & '_' & ('A' or 'B') & '(' & Day(Date#(Left(date, 18),'YYYYMMDD')) & ')', //Number Part Date#(Left(date, 18), 'YYYYMMDD') )

topic Chart expressions in QlikView

Chart expressions

Re: Chart expressions