Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
vipin_mishra479
Creator II
Creator II

Need to Count Number of Days

Hi All,

here i have attached the excel file where i make a mokeup data

In the attached excel i have four cloumn

Year   Month   Day   Counter

against each day i have counter as 0 and 1 where 1 is working days and 0 means non working days. Now based on excell data i want calculate no of days for each month and year

the out put result i have mention in excell please look and provided me a feed back.

12 Replies
MarcoWedel

Hi,


If(Counter,AutoNumber(RecNo(),Year&Month&Region),0) as Output 



should work in this case


regards


Marco

MarcoWedel

Yes, you can use the url of a data file attached to a thread as the source of a QlikView load statement to directly load sample data from the thread itself into your solution. I think that's quite a convenient way to create sample applications because neither the author nor anyone else who wants to execute a reload has to manually download the data file (and maybe edit the source path of the load statement).

sunny_talwar

That is pretty awesome... will try this at home (work doesn't allow me to do web links from community)