Set analysis problem

[vijaysahu2]

Hi All

My  one of the text box is written the below Set expression and I am getting hard time to understand it.

How is this  pulling data from data model?.

What are the importance of these given fields ?

Are they excluded or included in a selection ?

Can anyone please explain this here because whatever my understating is I am not able analyze or debug this code to get the exact data what is doing automatically . Or someone could guild or explain how to debug or analyze data in qlikview data model ..I find it very hard.

=num((Count({<Date, Year, Week, MonthYear, Quarter, Month, Weekday>}[Sales)])) / 30,'#,##0')

[sunny_talwar · Accepted solution]

All the fields within set analysis is saying is that ignore any selections in the Date, Year, Week, MonthYear, Quarter, Month and WeekDay field. So, basically if you make any selection in Date, the result of your expression won't change.

[kennethmash]

It's basically saying

1) ignore any selections for the fields Date, Year, Week, MonthYear, Quarter, Month, Weekday

2) count the number of Sales values

3) divide that count by 30

4) format the result of 3) into a number with the format '#,##0'

[vijaysahu2]

Thanks Sunny .. I just played around with that and got it meaning..

Below expression is also doing the same thing what earlier one was doing ...This is also ignoring fields

Hierarchy, [Application Family], Date, Year, Week, MonthYear, Quarter, Month, Weekday and only retrieving records

where Status is 'Open'. Am I correct here ?

=num(Avg({<Hierarchy, [Application Family], Date, Year, Week, MonthYear, Quarter, Month, Weekday, [Status]={'Open'}>}[OpenDays]),'#,##0.0') & ' Days'

[sunny_talwar]

Yup you are absolutely right....

[vijaysahu2]

How this is calculating data

=num(avg({<Date, Year, Week, MonthYear, Quarter, Month, Weekday, [Simplified Status]={'Open'}>}if([Days Open] < Fractile({<Date, Year, Week, MonthYear, Quarter, Month, Weekday, [Simplified Status]={'Open'}>}TOTAL [Days Open], .9), [Days Open])), '##.## Days')