topic Display values in Textbox in QlikView

Display values in Textbox

paulwalker — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Display values in Textbox

Kushal_Chawda — Sat, 23 Apr 2016 07:10:44 GMT

What is expected output for current selection in text box?

Re: Display values in Textbox

kkkumar82 — Sat, 23 Apr 2016 07:25:42 GMT

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

Re: Display values in Textbox

sunny_talwar — Sat, 23 Apr 2016 11:56:45 GMT

This?

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%')