topic How to use- Dual() in QlikView

How to use- Dual()

shabarish0587 — Mon, 11 Mar 2019 17:10:24 GMT

Hi Friends,

Can any one help me how to create WEEKENDSAT by using YearMonth Fields. My Data Looks like this.

Load * Inline

[

YearMonth, IDs

2018-12, 123

2018-12, 125

2019-01, 456

2019-01,789

2019-01, 281

];

My Data is look like this. If i select any yearmonth data it should display count of ids by weekend.

Re: How to use- Dual()

Gysbert_Wassenaar — Mon, 11 Mar 2019 17:41:54 GMT

Can you explain what WEEKENDSAT is?

And what has the Dual() function to do with it?

Re: How to create Weekend column by using Year month data

shabarish0587 — Mon, 11 Mar 2019 18:31:14 GMT

Hi Gysbert,
Weekendsat means Week End Saturday. I want to show the data by week, that week starts from Sunday and End with Saturday. I need to create like this
Weekend((Date) 0,6) as Weekendsat.
But here my case is I want to create same thing by using YearMonth Column not Date.

Re: How to create Weekend column by using Year month data

Gysbert_Wassenaar — Tue, 12 Mar 2019 07:09:16 GMT

Perhaps like this: Date(WeekEnd(Date#(YearMonth,'YYYY-MM')),'YYYY-MM-DD')