topic Re: Set Expression is not Working in QlikView

Set Expression is not Working

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I want to show week level data. And only to show data for WeekBeginDate for each week. Not summation of all dates.

I am using below expression:

sum({<DateSel = {Date(CstWeekBeginDate)}>}OrderQuantityOutstanding)

It is not working.

Can you please help me on this.

Thanks,

Sarif

Re: Set Expression is not Working

kaushiknsolanki — Fri, 21 Apr 2017 05:22:02 GMT

Hi,

The best way is you define this first date in script and create a flag of the same.

So your mastercal should look like below.

Load Date,

if(Floor(Date) = Floor(weekstart(Date)),1,0) as WeekStartDateFlag

....

From xyz;

Now in set expression you just need to use this flag, like below.

Sum({<WeekStartDateFlag = {"1"}>}OrderQuantityOutstanding)

This expression will give you data for only 1st day of the week.

Regards,

Kaushik Solanki

Re: Set Expression is not Working

mhmmd_srf — Fri, 21 Apr 2017 08:08:19 GMT

is week start Monday? As our DB WeekStart Date is Sunday.

But if i do minus 1 . Then also it is not working.

Thanks,

Sarif

Re: Set Expression is not Working

Fri, 21 Apr 2017 08:13:30 GMT

Can u pls share ur application

or change it weekstart sun in above environmental variables

Re: Set Expression is not Working

mhmmd_srf — Fri, 21 Apr 2017 08:20:32 GMT

I am not able to find weekstart in Environment variable.

Re: Set Expression is not Working

kaushiknsolanki — Fri, 21 Apr 2017 08:32:52 GMT

Hi,

In your environment variable look for

FirstWeekDay, default value is 6 which is sunday, you can make it 0 for Monday.

Regards,

Kaushik Solanki

Re: Set Expression is not Working

Fri, 21 Apr 2017 09:00:03 GMT

Set Daynames is there variable u can change the order of days

Re: Set Expression is not Working

mhmmd_srf — Fri, 21 Apr 2017 09:54:34 GMT

I set like this:

SET DayNames='Sun;Mon;Tue;Wed;Thu;Fri;Sat';

still not working.

Thanks,

Sarif

Re: Set Expression is not Working

prachisangewar — Fri, 21 Apr 2017 10:02:55 GMT

Hi,

You can even create a Master Calendar in you Model having Date and WeekDay and in the Set analysis you can use Weekday = Mon

Sum({<Weekday= {'Mon'}>}OrderQuantityOutstanding)