Toggle for Daily / Weekly / Monthly Aggregation

[afsarshaikh]

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

[Gysbert_Wassenaar]

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.

[afsarshaikh]

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

[Gysbert_Wassenaar]

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.

[afsarshaikh]

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

[neetu_singh]

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

[tresesco]

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.

[afsarshaikh]

thanks neetu.

i wants to add aggregation on sum(count).

Regards,

Afsar

[afsarshaikh]

thanks tresesco. i'll try to implement this