topic Re: # count in QlikView

# count

Mon, 17 Mar 2014 11:07:59 GMT

Hi all,

I want to count the total of trucks used in my table.

Dimension = Week, performanceday

Expression = count(distinct(trucks))

now I like to only count monday -> friday so i was thinking about this:

count(DISTINCT{< Year = {$(=(max(Year)))}, PerformanceWeekday = {'mo'} + PerformanceWeekday ={'tu'} + PerformanceWeekday ={'we'} + PerformanceWeekday ={'th'} + PerformanceWeekday ={'fr'} >}trucks)

i'm pretty sure this won't work so whats the best solution?

kind regards

Re: # count

manojkulkarni — Mon, 17 Mar 2014 11:10:32 GMT

can you post you application ? Instead of putting so many set, it can be achieved by adding one flag for performance.

Re: # count

MK_QSL — Mon, 17 Mar 2014 11:11:33 GMT

count(DISTINCT{< Year = {$(=(max(Year)))}, PerformanceWeekday = {'mo','tu','we','th','fr'} >}trucks)

Re: # count

its_anandrjs — Mon, 17 Mar 2014 11:13:30 GMT

Hi,

In place of this you have to load data from Monday to Friday and max year then it will show right data.

Thanks & Regards

Re: # count

Mon, 17 Mar 2014 11:14:02 GMT

god how could I make such an error. thanks!

Re: # count

senpradip007 — Mon, 17 Mar 2014 11:16:11 GMT

try like this:

count({< Year = {$(=(max(Year)))}, PerformanceWeekday = {"*"} - {'Sat','Sun'} >} DISTINCT trucks)

I assume that PerformanceWeekday holds the weekday name, eg- Sat,Sun,Mon, etc