Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
krishna789
Creator II
Creator II

i want restrict the text boxs filtering?

i have 5 text box 

1 past due

2 expedite

3 hot

4 in-transit

5.not picked up

each text box has one table ,in text box i use =if(GetSelectedCount(CustomerName) = 1 , Count( DISTINCT {<PShipment=>}PShipment),  similar each text box .i gave variables  in layout  of table so that if we press past due text box will come.similarly reamining  and count of customer will shown .but while selecting one customer it should become value 1

my question is for example  when i am selecting one customer id like past due  reamining  box value also changing like expedite ,hot....

how restrict   reaming  text box  values

6 Replies
pradosh_thakur
Master II
Master II

Hi

This is how associative property of QLIKVIEW works.When you select something the associated value will be white or grayed if not associated. It will not effect your getselectedcount value  of the other filters.

regards

Pradosh

Learning never stops.
andrei_delta
Partner - Creator III
Partner - Creator III

hello,

maybe in set analysis you can put 1 because - "Represents the full set of all the records in the application, irrespective of any selections made."


Regards,

Andrei

krishna789
Creator II
Creator II
Author

hi

actually taking {1}   is good  but problem is  {1}  is taking all shipments   but i want for only each customer shipments in pastdue ,hot,..etc. 

pradosh_thakur
Master II
Master II

try using p() function in your expression

Learning never stops.
krishna789
Creator II
Creator II
Author

hi

thanks for your response .my equation is =   if(GetSelectedCount(CustomerName) = 1 , Count( DISTINCT(PShipment)  ,so  i   am    not  using set analysis.

pradosh_thakur
Master II
Master II

can you post your sample app?

Learning never stops.