topic Re: Need Help in QlikView

Need Help

dhanu_today — Wed, 21 May 2014 18:51:45 GMT

Hi All,

I have the fields like ID,IDSTARTDATE,PRODUCT,IDOPENDATE.

I have to count the ID's which are having the product as CASA in particular month. E.g. March14.(IDSTARTDATE)

secondly i have to count the ID'S which are in IDSTARTDATE(March 14) for the PRODUCT CASA and which are having FD in next month

i.e(IDOPENDATE April14)

The same above mentioned output is also attached with sample data.I have tried with e() and p() functions but stuck some where.

Let me know if in case of any details required.

Thanks in adv,

Dhanu

Re: Need Help

dhanu_today — Wed, 21 May 2014 19:10:18 GMT

Any hint from anyone...

Re: Need Help

arthur_dom — Wed, 21 May 2014 19:22:09 GMT

FD Is WHAT? forecast Date?

Re: Need Help

arthur_dom — Wed, 21 May 2014 19:24:02 GMT

ah i found on second sheet o xls

Re: Need Help

dhanu_today — Wed, 21 May 2014 19:26:56 GMT

FD is the PRODUCT....In the secondary i have count the ID's which are having in the IDSTARTDATE(in March) as well as having PRODUCT FD IN April(IDSTARTDATE).

OUTPUT:
ID	CASA	CASA+FD	CA	SA
100	1	1	YES	YES
101	1	0	YES	YES
109	1	1	YES	YES

Let me know any thing req.

Thanks,

Dhanu

Re: Re: Need Help

arthur_dom — Wed, 21 May 2014 19:34:15 GMT

Se attached QVW, if it helps you.

Re: Need Help

dhanu_today — Wed, 21 May 2014 19:44:53 GMT

Thanks Arthur..Its helpful....Any chance to develop the same in front end using set analysis.Because all the fields are

coming from different tables in original data model and to reduce complexity at data model..

Re: Need Help

arthur_dom — Wed, 21 May 2014 19:48:31 GMT

Well... It is... you can create the monthopen_1 in calendar dimension. Or you could try to develop the application in different levels (1 to extract the data, 1 to treat the data -storing in qvd files, and 1 to show data) in this way it's easier to develop.

If you don't have a calendar dimension to do this, it will be far more complicated, but possible...