topic need help in QlikView

need help

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

I need the count of customer when user selects particular date in date filter.But if there is no date selected it will show data of ytd .

vishsaggi — Mon, 27 Mar 2017 16:58:39 GMT

May be Try this in your expression?

= IF(GetselectedCount(Yourdatefield) = 0, Count(DISTINCT {< Year = {"= $(= Max(Year))" } >} Customer), Count(Distinct Customer) )

devarasu07 — Mon, 27 Mar 2017 17:03:25 GMT

Hi,

Please refer to the attached sample app,

try like below,

if(GetCurrentSelections(Date),count(DISTINCT Barcode),

count({<CurrYTDFlag={'1'}>}DISTINCT Barcode))

Naga suggested fuction GetselectedCount works,

Refer to the attached sample,

= IF(GetselectedCount(OrderDate) > 0, Count(Distinct OrderID),Count(DISTINCT {< Year = {$(=Max(Year))}>} OrderID))

Thanks,Deva