topic Aggr not working in QlikView

Aggr not working

Thu, 06 Aug 2015 13:01:29 GMT

Hello,

I require no of users for time interval for one month, so I use (count(distinct KnownAs),T_date) as expression but when I click on any month Its all of sudden started showing for only one time interval in "Count of Users by Time Interval 2" chart. and in first chart "Count of Users by Time Interval", It is clearly showing other interval

Whats wrong in this.

Thanks

Re: Aggr not working

simospa — Thu, 06 Aug 2015 15:46:06 GMT

Hi,

can't open the file, have you set section access?

Re: Aggr not working

Thu, 06 Aug 2015 15:54:53 GMT

Hi,

uploading new one. try this.

Re: Aggr not working

dasaradh — Thu, 06 Aug 2015 18:02:21 GMT

hey i have also same prob i want count the customers having more than having bal 50000 in exp level.

here i have sample data

LOAD * INLINE [

cust no, acc no, bal

1, 1a, 15000

2, 2a, 50000

3, 3a, 20000

4, 4a, 20000

1, 1b, 12000

2, 2b, 5000

5, 5a, 60000

];