topic set analysis query in QlikView

set analysis query

Thu, 09 Feb 2012 07:12:07 GMT

Dear experts,

I have Dates(YYYY-MM-DD) as follows,

Date1 Value

2004-04-03 10

2004-06-02 20

2004-11-02 30

2004-03-31 40

2005-04-01 50

2005-10-06 60

2005-03-31 70

2006-04-01 80

2006-06-20 90

2006-10-30 100

Now I want YearWise count of Value in a bar chart.

ex. 2004 - 4

2005 - 3

2006 - 3

Is this Possible by set analysis????

I tried : count({$<Date1 = {'>={$(=min(Date1)) <= {$(=max(Date1))}}'}>}Value)

when no selection is there it will take '2004-04-03' as Min and '2006-10-30' as Max but i want Yearwise in Bar....

Please help on this will be greatly appreciated........

Regards,

Vaibhav

set analysis query

kaushiknsolanki — Thu, 09 Feb 2012 07:52:31 GMT

HI,

Just include dimension as =Year(Date)

and expression as count(Value)

Regards,

Kaushik Solanki

Re: set analysis query

jagan — Thu, 09 Feb 2012 08:22:14 GMT

Hi,

Please check the attached file for solution. You can also do this by using Calculated Dimension without adding a new Field(Year).

If you are using Year in multiple widgets just follow what kaushik suggested. The script for adding Year Field is below

Values:

LOAD

Date1,

Value,

Year(Date1);

LOAD * INLINE [

Date1, Value

2004-04-03, 10

2004-06-02, 20

2004-11-02, 30

2004-03-31, 40

2005-04-01, 50

2005-10-06, 60

2005-03-31, 70

2006-04-01, 80

2006-06-20, 90

2006-10-30, 100

];

Regards,

Jagan.

set analysis query

Thu, 09 Feb 2012 10:11:28 GMT

Thanks....