topic Re: Showing incorrect data while applying set analysis in QlikView

Showing incorrect data while applying set analysis

neha_sri — Thu, 18 Sep 2014 19:13:53 GMT

Hi,

I have created a data model linked with calender.Now I have added one more table that also contains date field and I don't want to link that date field with calender,but in front end I want to show data based on calender year,month selection.So i have tried below mentioned set analysis

=count({<[Code]={'M'},Year=p([Restore Year]),Month=p([Restore Month]),Year=,Month=>}[WO ID])

where Year and Month are my calender year and month and

Restore Year and [Restore Month] are created from my new table date

The above expression is not showing the correct data.

Please help me out.Thanks in anticipation

Re: Showing incorrect data while applying set analysis

danielblank — Thu, 18 Sep 2014 19:29:39 GMT

Have you validated the month value? Are Month and Restore Month in the same format?

Maybe they are numeric and alphabetic, like 3 and Mar...?

In this case, you should create an addition field like MonthNum and RestoreMonthNum in the script.

Kind regards,

Daniel

Re: Showing incorrect data while applying set analysis

neha_sri — Thu, 18 Sep 2014 19:33:19 GMT

The format for month and restore month are same

Re: Showing incorrect data while applying set analysis

danielblank — Thu, 18 Sep 2014 19:38:23 GMT

numeric?

Re: Showing incorrect data while applying set analysis

danielblank — Thu, 18 Sep 2014 19:50:04 GMT

Another thing that caught my eye: the syntax of the p()... it should be like this:

Count({$<Year={[Restore year]}, Month={[Restore Month]}>} [WO ID])

Using P() in Set Analysis would require another syntax, like

Count({$<CustomerID=P({1<Product={'Shoe'}>})>} CustomerID)

Re: Showing incorrect data while applying set analysis

Thu, 18 Sep 2014 21:40:22 GMT

try this:

=count({<[Code]={'M'},Year=P([Restore Year] = Year),Month=P([Restore Month] = Month),Year=,Month=>}[WO ID])

Re: Showing incorrect data while applying set analysis

jagan — Fri, 19 Sep 2014 03:52:49 GMT

Hi,

Try like this

=count({<[Code]={'M'},Year=P([Restore Year]),Month=P([Restore Month])>}[WO ID])

Regards,

Jagan.