Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Display values in Textbox

Hi Community,

I have developed one scatter chart..

Suppose if i have Target Percentage  above 60%..

Total no.of Product-name:

Target Value:

Percentage of Selection:

These 3 values i want show in textbox.

Based on selection i have to change the values in textbox.

PFA,

Thanks in Advance....

3 Replies
Highlighted

Re: Display values in Textbox

What is expected output for current selection in text box?

Specialist III
Specialist III

Re: Display values in Textbox

For which selections you want this to be happened, can you clear it some more

Highlighted

Re: Display values in Textbox

This?

Capture.PNG

1st Expression

=Count(DISTINCT Aggr(If(IF(vMin='--Select--' or vMax='--Select--', (Sum({<Month>}LineSalesAmount) / Sum({<Month,Year = {$(=Max(Year)-1)}>}OrderSalesAmount) -1),

  if(Sum(LineSalesAmount)>=$(vMin) and Sum(LineSalesAmount)<=$(vMax),

  (Sum({<Month>}LineSalesAmount) / Sum({<Month,Year = {$(=Max(Year)-1)}>}OrderSalesAmount) -1))) >= 0.60, ProductName), ProductName))

2nd Expression

=Money(Sum(Aggr(If(IF(vMin='--Select--' or vMax='--Select--', (Sum({<Month>}LineSalesAmount) / Sum({<Month,Year = {$(=Max(Year)-1)}>}OrderSalesAmount) -1),

  if(Sum(LineSalesAmount)>=$(vMin) and Sum(LineSalesAmount)<=$(vMax),

  (Sum({<Month>}LineSalesAmount) / Sum({<Month,Year = {$(=Max(Year)-1)}>}OrderSalesAmount) -1))) >= 0.60,

  Sum({<Month>}LineSalesAmount)), ProductName)))

3rd Expression

=Num(Avg(Aggr(If(IF(vMin='--Select--' or vMax='--Select--', (Sum({<Month>}LineSalesAmount) / Sum({<Month,Year = {$(=Max(Year)-1)}>}OrderSalesAmount) -1),

  if(Sum(LineSalesAmount)>=$(vMin) and Sum(LineSalesAmount)<=$(vMax),

  (Sum({<Month>}LineSalesAmount) / Sum({<Month,Year = {$(=Max(Year)-1)}>}OrderSalesAmount) -1))) >= 0.60,

  1-Sum(LineSalesAmount)/

  Sum(OrderSalesAmount)), ProductName)), '##.00%')