topic Re: Set Analysis in QlikView

Set Analysis

rahulsingh12 — Wed, 28 Jun 2017 13:38:31 GMT

Hi,

How Should I write my expression if i want the last 6 months data to be selected from the current selected month?

Regards,

Re: Set Analysis

sunny_talwar — Wed, 28 Jun 2017 13:40:34 GMT

May be this

{<Date = {"$(='>=' & Date(MonthStart(Max(Date), -6), 'DateFieldFormatHere') & '<=' & Date(Max(Date), 'DateFieldFormatHere'))"}, Month>}

Re: Set Analysis

rahulsingh12 — Wed, 28 Jun 2017 13:49:29 GMT

It is showing error in expression

Re: Set Analysis

sunny_talwar — Wed, 28 Jun 2017 13:50:51 GMT

No idea what you used, I just showed you how the basic syntax looks like...

Re: Set Analysis

rahulsingh12 — Wed, 28 Jun 2017 13:55:21 GMT

{<Date = {"$(='>=' & Date(MonthStart(Max(Commondate), -6), ''mm/dd/yyyy'') & '<=' & Date(Max(commondate), 'mm/dd/yyyy'))"}, commonmonth>}

I have replaced it with the fields I have

Regards,

Re: Set Analysis

sunny_talwar — Wed, 28 Jun 2017 13:59:46 GMT

What is the expression you used my friend?

Re: Set Analysis

rahulsingh12 — Wed, 28 Jun 2017 14:08:21 GMT

I am new to set so maybe not using the expression properly.

I have two fields Common month and Common year in the selection.

where should I fit it in the expression/

Re: Set Analysis

sunny_talwar — Wed, 28 Jun 2017 14:11:18 GMT

What was your expression where you were trying to implement this?

Re: Set Analysis

rahulsingh12 — Wed, 28 Jun 2017 14:25:47 GMT

It was just count(A) that's it.

Regards,

Re: Set Analysis

vishsaggi — Wed, 28 Jun 2017 14:29:03 GMT

Based on your expr is this what you were trying?

= Count({<Date = {"$(='>=' & Date(MonthStart(Max(Commondate), -6), 'mm/dd/yyyy') & '<=' & Date(Max(commondate), 'mm/dd/yyyy')) }, commonmonth >} YourActualField)

Re: Set Analysis

rahulsingh12 — Wed, 28 Jun 2017 20:08:43 GMT

if I give max(datefield) then will it take the current selected date or the max of the date available?

regards,

Re: Set Analysis

sunny_talwar — Wed, 28 Jun 2017 23:29:57 GMT

Current selected date will be your max date unless you ignore selection in date field using set analysis

Re: Set Analysis

pathiqvd — Thu, 29 Jun 2017 05:05:58 GMT

Hi Rahul,

In script level write like this:-

date(MakeDate(Year(Date),Month(Date)),'MM-YYYY') as yy_mm

and write expression as

sum({<yy_mm={">=$(=date(MonthStart(AddMonths(min(yy_mm),-6)),'MM-YYYY'))<=$(=date(max(yy_mm),'MM-YYYY'))"}>}Sales) and also take filter yy_mm field . I think you will get solution.

Regards,