Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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.
try using p() function in your expression
hi
thanks for your response .my equation is = if(GetSelectedCount(CustomerName) = 1 , Count( DISTINCT(PShipment) ,so i am not using set analysis.
can you post your sample app?