Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Nikhith
Contributor
Contributor

Show Bar Chat data in Text Box

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

Labels (2)
7 Replies
dplr-rn
Partner - Master III
Partner - Master III

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.
Nikhith
Contributor
Contributor
Author

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

and Expression : Sum (Sales)

 

if i click on 2016 display 2016 sales in text box

 

dplr-rn
Partner - Master III
Partner - Master III

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

Create Textbox with 2 measures:

Measure 1: =getfieldselections(Year)

Measure 2: =sum(Sales)

dplr-rn
Partner - Master III
Partner - Master III

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

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 

 

dplr-rn
Partner - Master III
Partner - Master III

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-ins...

 

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