This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
I'm new to Qlik View, I faced this case, and I need your help please.
I have month and year master calendar Filter Please tell the expression when I select any one of month and year, I want the present EmpID Count only for the selected Month and year
[Joining Date] as Joining_Date,
If(Len(Trim(RelevingDate)) = 0, Today(), RelevingDate) as Releving_Date
(html, codepage is 1252, embedded labels, table is @1);
LOAD Min(Joining_Date) as Min,
Max(Releving_Date) as Max
LET vMin = Peek('Min');
LET vMax = Peek('Max');
DROP Table MinMax;
MonthName(Date) as MonthYear,
Year(Date) as Year,
Month(Date) as Month;
LOAD Date($(vMin) + IterNo() - 1) as Date
While $(vMin) + IterNo() - 1 <= $(vMax);
Left Join (Table)
Assuming you already have a master calendar, the script is red is what you will need to make a connection between your master calendar and the fact table.
View solution in original post