topic Re: Data from two dates. in QlikView

Data from two dates.

Mon, 30 Nov 2015 08:45:47 GMT

Hi,

I want to generate a report such that selection of the report will be any two months(Dynamic) and what the report should generate is the details of the employees who are available in the minimum month selection but not available in the maximum month selection.

Regards,

Kavya

Re: Data from two dates.

swuehl — Mon, 30 Nov 2015 10:32:46 GMT

Maybe like

=Concat(

{<EmployeeName = p({<MonthNum = {$(=Min(MonthNum))} >}) * e({<MonthNum = {$(=Max(MonthNum))} >}) >} EmployeeName)

Post some sample data if you need more specific help with the set expression.

Re: Data from two dates.

mohitd910 — Mon, 30 Nov 2015 10:50:26 GMT

Hi kavyasri,

You Can you Start Date and End Date Function in Expression Set or by Set analysis you can easily got data from two dates

Re: Data from two dates.

avinashelite — Mon, 30 Nov 2015 10:53:05 GMT

post your app with sample data....that will help us to provide the solution

Re: Data from two dates.

Mon, 30 Nov 2015 11:06:53 GMT

Hi,

LOAD * INLINE [

Month, empname

Jan, a

Jan, b

Jan, c

Feb, a

Feb, b

Mar, a

Mar, b

Mar, d

];

if i click on Jan and March (any month)i should get empname 'c', i.e details of the employees who are available in the minimum month selection but not available in the maximum month selection.

Re: Data from two dates.

swuehl — Mon, 30 Nov 2015 17:06:56 GMT

In your load script

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

LOAD *, Num(Month(Date#(Month,'MMM'))) as MonthNum

INLINE [

Month, empname

Jan, a

Jan, b

Jan, c

Feb, a

Feb, b

Mar, a

Mar, b

Mar, d

];

Then in the frontend, e.g. in a text box:

=Concat(

{<empname = p({<MonthNum = {$(=Min(MonthNum))} >}) * e({<MonthNum = {$(=Max(MonthNum))} >}) >} empname)

Re: Data from two dates.

Tue, 01 Dec 2015 09:36:04 GMT

Thank you