topic Current Year store count in QlikView

Current Year store count

renjithpl — Wed, 26 Sep 2012 06:38:22 GMT

Hi All,

I have a field Store_Open_Date and I wan to do the count of Stores which has opened in the current year.

Regards

Ren

Re: Current Year store count

Wed, 26 Sep 2012 06:46:12 GMT

Hi,

For example

You could get the Year from your Store_Open_Date field and name it as Store_Open_Year. Use the Store_Open_Year in your set analysis that looks like this.

count({<Store_Open_Year = {$(=max(Store_Open_Year))} >} Distinct Stores) .

Regards,

Janzen

Re: Current Year store count

nilesh_gangurde — Wed, 26 Sep 2012 06:53:00 GMT

Create a Master calender which will have following fields:

Day,

Month,

Year,

MonthYear

and then Create the table having dimension and expression as you want

and make selection in the year field for which you want to get the count.

in this case Expression will be : Count(Distinct Stores)

You can hardcore the chart by using the following expression in the chart.

Count ( {<Store_Open_Date = {"=Year(today())"}> } Distinct Stores)

Re: Current Year store count

renjithpl — Wed, 26 Sep 2012 07:14:00 GMT

I tried as suggested it works,

count({<DIM_STORE_OPEN_YEAR = {$(=year(today()))} >} Distinct DIM_STORE_SHORTNAME)

now i want only these store names in a list box

Re: Current Year store count

Wed, 26 Sep 2012 07:24:37 GMT

Hi,

If Mr. Nilesh's answer works, you should tag it as right answer.

now, for your NEW question about how to create a listbox with only those brances, you could try this.

aggr(only({<DIM_STORE_OPEN_YEAR = {$(=year(today()))} >} DIM_STORE_SHORTNAME),DIM_STORE_SHORTNAME)

Regards,

Alex

Re: Current Year store count

renjithpl — Wed, 26 Sep 2012 07:29:09 GMT

Thanks a lot, i forgot to use "Only".

Re: Current Year store count

nilesh_gangurde — Wed, 26 Sep 2012 09:10:46 GMT

Thanks Alexis Tan,renjithpl

Regards,

Nilesh Gangurde