topic Re: computing values on a bar chart based on a variable in QlikView

computing values on a bar chart based on a variable

Mon, 05 Jan 2015 21:58:41 GMT

Hi All,

I am trying to create a qlikview bar chart with 2 bars, one showing the selected client's (saying C1) value (say sales) and other showing the average of 4 clients sales (say C1 C2 C3 C4)....I am not able to compute average AND show the individual client value ....Client can change so I also need an option to change the client (I have kinda got that worked out by creating a variable for it).... It would be great if someone please help me with a sample example or any other suggestions welcome

In short looking to create a bar chart showing with 2 bars (Client and Average) and an option to change the client

Thanks for the help.

Karthik

Re: computing values on a bar chart based on a variable

Tue, 06 Jan 2015 00:51:51 GMT

The simplest and quickest I could think of was to display all four dimensions on x-axis along with total as the fifth dimension. Pls see attached.

Thanks

Re: computing values on a bar chart based on a variable

jagan — Tue, 06 Jan 2015 02:31:35 GMT

Hi,

Try like this

Expression for selected Client:

=Sum(Sales)

Expression for remaining Clients:

=Sum({1-$}Sales) /Count({1-$} DISTINCT Client)

Hope this helps you.

Regards,

Jagan.

Re: computing values on a bar chart based on a variable

djsampat — Tue, 06 Jan 2015 03:33:44 GMT

I have combined the two earlier responses and made a sample file to match your requirement using a Resident Load.

Average Sales

If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer

If you are viewing this topic and found it informative, please like my comment.

Regards

Dhruv

Re: computing values on a bar chart based on a variable

Tue, 06 Jan 2015 14:32:00 GMT

Dhruv,

Thank you for the response. This was close...sticking to your example, I have more than 100 products so its not feasible for me to show all products in a single chart .... is there an option where we can have an Input Box and select a company to dynamically change the <client> on the chart?

I tried your resident load method, it gives me the following error

Table not found

Average:

LOAD

Sum([Overall Impact From 3R's])/Count(DISTINCT [Overall Impact From 3R's]) as Averageoverallimpact3Rs

resident [Overall Impact From 3R's]

Instead of the above .. can I just not have another expression for average? like avg(sales) ?

Please let me know what you think.

Thanks

Karthik

Re: computing values on a bar chart based on a variable

Tue, 06 Jan 2015 20:06:17 GMT

Please see attached. I think this should work for you. You will have only two bars. One for the product and the other is total.

Thanks

Re: computing values on a bar chart based on a variable

Tue, 06 Jan 2015 21:22:18 GMT

Ajay, I do not see any attachment from you? Can you please resend the attachment? Thanks.

Re: computing values on a bar chart based on a variable

Tue, 06 Jan 2015 21:28:36 GMT

Can you see it now?

Re: computing values on a bar chart based on a variable

djsampat — Thu, 08 Jan 2015 00:42:02 GMT

You can use either of the following:-

avg(TOTAL Sales)

avg({1} TOTAL Sales)

If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer

If you are viewing this topic and found it informative, please like my comment.

Regards

Dhruv