Toggle in graphs

[alan_grn]

I am new to QlikView and am trying to do the following:

I have a calendar setup with days, weeks, months and prodcuts in my databse.

I am able to show a line graph for all prodcuts (Total of all) or a graph listing each individual prodcuct (Multiple lines) I would like to be able to toggle the graph between showing the graph as a single line or as multiple lines depending on a user selction. What si the best practice to do this?

I also wantto be able to to adjust the formula base don another selection. If Daily is slected then SUM otherwise AVG. Can someone please tell me if this is possible.

[alan_grn]

I have nearly got it to work.

I have added the ADte dimension and then created a variable with the code below.

=if(Type='Daily','PRODUCT_TYPE_NAME')

Ii works when Type = DAily. When Not Daily, I do not wnat the dimension to appear in teh chart. At the moment this brings back all the fields.

[disqr_rm]

=if(Type='Daily','PRODUCT_TYPE_NAME', 'Date')

[alan_grn]

Thanks. The date dimension has already been added. If I use your code Date appears twice in the dimension. I can remove it and would then something like

=if(Type='Daily','PRODUCT_TYPE_NAME' AND 'Date', 'Date')