topic Re: Toggle for Daily / Weekly / Monthly Aggregation in QlikView

Toggle for Daily / Weekly / Monthly Aggregation

afsarshaikh — Fri, 23 Aug 2013 10:36:48 GMT

Hi All,

I dont know anything about how to add toggles in qlikview and I needs to add Toggle for Daily / Weekly / Monthly Aggregation in my dashboard.

Could anyone please help me out on this.

Thanks

Regards,

Afsar Shaikh

Re: Toggle for Daily / Weekly / Monthly Aggregation

Gysbert_Wassenaar — Fri, 23 Aug 2013 11:09:14 GMT

On the Groups tab of the Document Properties window you can create groups of fields. A group you create in this way can be used as a dimension in charts and listboxes. Groups allow you to easily change (toggle) the active field in the group and thus in the chart or listbox.

Re: Toggle for Daily / Weekly / Monthly Aggregation

afsarshaikh — Fri, 23 Aug 2013 15:59:13 GMT

Thanks for the reply.

But, what the client expecting is that i should use aggregation techniques as below:

For Monthly : Sum of 30 days,

Weekly : Sum of 7 days and

Daily : Sum of last day's data

Could you please me on that ?

Thanks in advance

Re: Toggle for Daily / Weekly / Monthly Aggregation

Gysbert_Wassenaar — Fri, 23 Aug 2013 16:24:21 GMT

Please post an example document with sample data and tell us what the result should look like based on the sample data. For the result you could create a table in an excel file.

Re: Toggle for Daily / Weekly / Monthly Aggregation

afsarshaikh — Mon, 26 Aug 2013 07:12:26 GMT

Actually, it's client confidential data and he doesn't allowed to do so.

Could you please advise me how to achieve this if you have any sample file for the same.

Thanks

Re: Toggle for Daily / Weekly / Monthly Aggregation

neetu_singh — Mon, 26 Aug 2013 11:48:43 GMT

Hi Afsar,

Can you elaborate your requirement as sum of what? or you want toggle with month, weekly or daily derived from date only or something else/

see if you want only from date field then you can use function month, week, day e.g. month(dates) as monthly ........

and then you can create a cyclic group from dimension tab in charts and then this group you can use as a dimension for toggle.

if this is not your requirement then plz elaborate that aggregation of what you want.

regards

neetu

Re: Toggle for Daily / Weekly / Monthly Aggregation

tresB — Mon, 26 Aug 2013 11:56:53 GMT

May be, you can try like this:

Create three expressions to sum three different periods' data, then group the expressions. Then for same dimension value, one would be able to toggle.

Re: Toggle for Daily / Weekly / Monthly Aggregation

afsarshaikh — Wed, 28 Aug 2013 12:18:59 GMT

thanks neetu.

i wants to add aggregation on sum(count).

Regards,

Afsar

Re: Toggle for Daily / Weekly / Monthly Aggregation

afsarshaikh — Wed, 28 Aug 2013 12:20:30 GMT

thanks tresesco. i'll try to implement this