topic Re: How to write expression in Set Analysis in QlikView

How to write expression in Set Analysis

Mon, 21 Oct 2013 10:31:14 GMT

Hi,

I have to show in line chart curent month employess and the dimension is Day of Month.

Can anyone help me how to write with set analysis as when i am using one dimesion as Month and other dimension as Day and expressions as Count(Distinct(EmployeeID) it is not showing correct values. please help.

Thanks.

Re: How to write expression in Set Analysis

Mon, 21 Oct 2013 10:37:01 GMT

If you have Dimensions:

- Month

- Day

And Expression: =count(distinct EmployeeID)

You can change your expression into: =count( TOTAL <Month> Distinct EmployeeID)

This will allow your expression to skip being filtered by all the chart dimensions but Month.

Re: How to write expression in Set Analysis

jagan — Mon, 21 Oct 2013 10:49:51 GMT

HI,

Try like this

Dimension : Day(DateDimension)

Expression : Count({<Day=, Week=, DateDimension={'>=$(=MonthStart(Max(DateDimension)))<=$(=Max(DateDimension))'}>} EmployeeID)

Hope this helps you.

Regadrs,

Jagan.

Re: How to write expression in Set Analysis

Mon, 21 Oct 2013 11:14:58 GMT

Thanks and you mean DateDimension means Date and if I want to have MonthSort also as dimension means how can I write?

Re: How to write expression in Set Analysis

jagan — Mon, 21 Oct 2013 13:09:17 GMT

Hi,

Yes, replace DateDimension with your date field and MonthStart is a function. Can you attach some sample data?

Regards,

Jagan.