Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Certification Exam Sale - 40% off. Register by June 30, 2020. GET DETAILS
Highlighted
Contributor

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?

Highlighted
Valued Contributor 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%')