topic Toggle in graphs in QlikView

Toggle in graphs

alan_grn — Tue, 16 Feb 2010 19:04:03 GMT

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.

Toggle in graphs

disqr_rm — Tue, 16 Feb 2010 19:20:13 GMT

THis can be achieved in many ways. One of the way you could take is. you can define a variable vExpression:

if(Type='Daily', 'sum(field)', 'avg(field)')

And then use this $(vExpression) as the expression of the chart.

To toggle, you could to the same trick with dimensions, or even can have 2 charts on same position and enable/disable them with a condition checking what is selected.

Still a problem, please post a sample qvw and someone here will provide a solution for your reference.

Hope this helps.

Toggle in graphs

alan_grn — Tue, 16 Feb 2010 19:46:23 GMT

Thanks. Sorry about this, but this new to me. I have managed to get the variable to work, but my time series all has the same value. (Sum of all time).

The expression is Sum([Amount]). How do I chaneg this so that it sums an amoutn for each Day.

Are you abel to answer the second aprt of my question above?

Toggle in graphs

disqr_rm — Tue, 16 Feb 2010 20:03:21 GMT

I already answered your sencond question.

Define a variable vExpression (under Settings -> Variable Overview menu) and put the value

=if(Type='Daily', 'sum([Amount])', 'avg([Amount])')

Then in the expression section of your chart use =$(vExpression) as expression. I am assuming the field name is "Type" which contains Daily or other values.

Toggle in graphs

alan_grn — Tue, 16 Feb 2010 20:14:21 GMT

Thanks will give it another try.

Regarding the variable. The formula changes correctly, but this add all time periods together. (i.e. each dat point has the same value but different days. How do I get this to sum for each day?

Toggle in graphs

disqr_rm — Tue, 16 Feb 2010 20:33:14 GMT

What is your dimension? Do you have TOTAL in your sum in expression?

I am not able to upload documents here for some reason. THis new Forum is giving me problems.

I can email it to you, if you provide one.

Toggle in graphs

alan_grn — Tue, 16 Feb 2010 21:02:44 GMT

Thanks for your help on this. I have created a simple example.

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/2553.Test.zip:550:0]

For variable vExp I get a straight line. It is summing the entire population and not by date.

I would alos like to see if it is possibel to toggle the diemnsion. Setting 1- Date, Setting 2would be Date and Product.

Toggle in graphs

disqr_rm — Tue, 16 Feb 2010 21:13:37 GMT

Use


='sum(total <Date, Product> [Value])'

as variable value. Please pay attention to single quotes around.

and put

=$(vExp)

in the expression.

Toggle in graphs

alan_grn — Tue, 16 Feb 2010 22:01:03 GMT

Thanks that worked. Now to play around and see if I can get it to work for the dimension.

Thanks for your help. It is really appreciated.

Toggle in graphs

alan_grn — Tue, 16 Feb 2010 22:08:13 GMT

Quick question. How would I do this for the Dimension.

I want this to be for Date and Product.

Toggle in graphs

alan_grn — Tue, 16 Feb 2010 22:26:51 GMT

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.

Toggle in graphs

disqr_rm — Tue, 16 Feb 2010 23:09:56 GMT

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

Toggle in graphs

alan_grn — Tue, 16 Feb 2010 23:17:09 GMT

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')