Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
If(Counter,AutoNumber(RecNo(),Year&Month&Region),0) as Output
should work in this case
regards
Marco
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).
That is pretty awesome... will try this at home (work doesn't allow me to do web links from community)