Qlik Community

Third-Party Qlik Jobs

Area for people to learn more about current Qlik related job postings.

Highlighted
Nikhith
New 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

7 Replies
dilipranjith
Valued Contributor II

Re: Show Bar Chat data in Text Box

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
New Contributor

Re: Show Bar Chat data in Text Box

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

and Expression : Sum (Sales)

 

if i click on 2016 display 2016 sales in text box

 

dilipranjith
Valued Contributor II

Re: Show Bar Chat data in Text Box

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

Re: Show Bar Chat data in Text Box

Create Textbox with 2 measures:

Measure 1: =getfieldselections(Year)

Measure 2: =sum(Sales)

dilipranjith
Valued Contributor II

Re: Show Bar Chat data in Text Box

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

Re: Show Bar Chat data in Text Box

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 

 

dilipranjith
Valued Contributor II

Re: Show Bar Chat data in Text Box

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

Community Browser