topic Show Bar Chat data in Text Box in QlikView

Show Bar Chat data in Text Box

Nikhith — Sat, 16 Nov 2024 05:01:33 GMT

Hi,

How to Show Bar Chat data in Text Box

Ex: In Bar chat year wise sales

if i click on year 2018 i want to show 2018 year total sales in text box

Re: Show Bar Chat data in Text Box

dplr-rn — Fri, 07 Dec 2018 12:41:20 GMT

What you described is straight forward sum(sales) in text box. When year is selected it will filter.
But I am sure your issur is more complicated than that.
Please explain more what the challenge is.

Re: Show Bar Chat data in Text Box

Nikhith — Fri, 07 Dec 2018 12:43:40 GMT

In bar chat Dimension : Year (2016,2017,2018)

and Expression : Sum (Sales)

if i click on 2016 display 2016 sales in text box

Re: Show Bar Chat data in Text Box

dplr-rn — Fri, 07 Dec 2018 12:47:41 GMT

Answer remains the same. Text box will have sum(sales).
If you want it be shown only one year is selected?

Re: Show Bar Chat data in Text Box

ggijben — Fri, 07 Dec 2018 12:47:46 GMT

Create Textbox with 2 measures:

Measure 1: =getfieldselections(Year)

Measure 2: =sum(Sales)

Re: Show Bar Chat data in Text Box

dplr-rn — Fri, 07 Dec 2018 12:51:56 GMT

If it is
Use if(getselectedcount (year), sum(sales),'select a year's)

Re: Show Bar Chat data in Text Box

Nikhith — Fri, 07 Dec 2018 12:58:24 GMT

iam using container it contains 3 bar chats

1. year wise sales

2. month wise sales

3. week wise sales

if i click on 1. year wise sales i need to display all years sales in text box and

click on one year in bar chat display selected year sales in text box

if i click on 1. month wise sales i need to display 12 month sales in text box and

click on one month in bar chat display selected month sales in text box

we can use two text boxes

Re: Show Bar Chat data in Text Box

dplr-rn — Fri, 07 Dec 2018 14:38:56 GMT

Ah ok.

there's not stright forward way to identify which chart is selected in container. You need macros. see below

https://community.qlik.com/t5/QlikView-App-Development/How-to-identify-which-Object-ID-is-active-inside-a-container/td-p/355768

Another option is to move away from containers and use text objects (and variables) as selections to show / hide the Year, monthly, weekly chart. From a UX point of view this is better IMHO. then use the same variables to show the appropriate expression in your text object