Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

List box expression created 0 1-10 11-20 may i know how to use button to turn on 0 ?


Hi All



Below expression work fine in my list box 1 :-


=If(Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE)  >0 and Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE)<10, dual('1-10',1),


If(Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE) >10 and Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE)<20, dual('11-20',2),


If(Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE) >20 and Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE)<30, dual('21-30',3),


If(Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE) >30 and Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE)<100, dual('31-100',4),


If(Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE) >100 and Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE)<2000, dual('101-2000',9), Dual('0', 0))))))



May i know how to turn on " Number of turn " = 0 by using the button ?


Paul Yeo


11 Replies
paulyeo11
Valued Contributor II

Re: List box expression created 0 1-10 11-20 may i know how to use button to turn on 0 ?

My QVW

Re: List box expression created 0 1-10 11-20 may i know how to use button to turn on 0 ?

What you want to show if you hit the button?

paulyeo11
Valued Contributor II

Re: List box expression created 0 1-10 11-20 may i know how to use button to turn on 0 ?

Hi Anil

I want to turn on number of turn = 0

Paul

Re: List box expression created 0 1-10 11-20 may i know how to use button to turn on 0 ?

Still Not sure, Sorry.

paulyeo11
Valued Contributor II

Re: List box expression created 0 1-10 11-20 may i know how to use button to turn on 0 ?

Hi Anil

Do you mean you not sure what i want to achieve ?

Paul Yeo

paulyeo11
Valued Contributor II

Re: List box expression created 0 1-10 11-20 may i know how to use button to turn on 0 ?

what is S mean ?

Re: List box expression created 0 1-10 11-20 may i know how to use button to turn on 0 ?

I am not followed you, What you are going to achieve. usually,We have concept called Auto Hide Show and Hide Multiple Objects - YouTube but your intend is bit different. Before produce some inputs if you explain exactly what your needed then it saves Time

paulyeo11
Valued Contributor II

Re: List box expression created 0 1-10 11-20 may i know how to use button to turn on 0 ?

turn on number of turn 0.png

Hi Anil

I need to do a drill down analysis , as stock number of turn = 0 , is having a issue. So i need to drill in these list of items , and further analyse those items by period. to find out the real issue.

Paul

Re: List box expression created 0 1-10 11-20 may i know how to use button to turn on 0 ?

It make sense now. Will looks this once i get chance to open the app

Community Browser