topic Re: Set Analysis in QlikView

Set Analysis

Wed, 31 Jul 2013 06:39:15 GMT

Hi community

I have a problem with set analysis in a expression.

Actually I want to calculate the count of data field excluding the current week.Here is my expression.Field and data are dummy fields

Count({$<[Week Date]={"<$(#vCurrentWeek)"},[Field)]={'>10'}>}[Data])

vCurrentWeek= Date(Max([Week Date]),'DD.MM.YYYY')

For example vCurrentWeek will be 28.07.2013 considering the last sunday

any help will be appreciated.

Re: Set Analysis

Wed, 31 Jul 2013 07:10:28 GMT

Try below...

Count({<[Week Date]={'<$(vCurrentWeek)'},Field={'>10'}>}[Data])

Regards-Bika

Re: Set Analysis

Wed, 31 Jul 2013 07:12:16 GMT

Thanks Bika

But unfortunately it is not working.still chart is not displaying any data .If I remove Week Date filter in the expression it is working fine.Some problem with the Week Date.

My week date is in the formate DD.MM.YYYY

Is this creating any problem here?

Regards

Murali Krishna

Re: Set Analysis

kaushiknsolanki — Wed, 31 Jul 2013 07:21:20 GMT

HI,

If you have done any selections then you must deselect them in set analysis.

Say for example if you have selected Month and Year then your expression should be.

Count({$<[Week Date]={"<$(#vCurrentWeek)"},[Field)]={'>10'},Month=,Year=,Week=>}[Data])

Also make sure that the date format of the [Week Date] field and the Variable is same.

Regards,

Kaushik Solanki

Re: Set Analysis

Wed, 31 Jul 2013 07:22:57 GMT

Try to change week date format DD.MM.YYYY to DD/MM/YYYY.

hope it will help u

Re: Set Analysis

Wed, 31 Jul 2013 07:24:17 GMT

try this

Count({$<[Week Date]={'<vCurrentWeek'},[Field)]={'>10'}>}[Data])

and check the format of [Week Date] and vCurrentWeek, both format should must be same

Re: Set Analysis

Wed, 31 Jul 2013 07:28:55 GMT

No luck Bika

Still same problem.

Re: Set Analysis

Wed, 31 Jul 2013 07:41:49 GMT

Still not working Vishwa