Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Here I am attaching my qvd and qvw files, Can you guys please help me out for the below mentioned challenge:
I have a multiple date columns in my file. Now i want to create master hierarchy calendar for and link with all the dates. because i want to show only one list box in my report i.e. hierarchy calendar list box. For that i wrote some script but i was strucked somewhere
Output scenario:
I want to create a text object for joiners
for that expression is like this: Count(candidateID) but these candidate id's count are based on plcdate column.
If i select April Month and 2018 year from hierarchy calendar list box output should be 15 for this text object.
Please Help me out from this guys.
mbaeyensmanoj217rwunderlichfranky_h79priyalvp24swuehlpetter-strdandamudistalwar1loveisfail
Thank you in advance
Kindly send the qvf
Hi Priyal
I already attached qvd file with the discussion. Please find and help me out from this
Not able to find it,please resend it
Hi Rajiv and rwunderlich,
My Requirement is: I want create 4 text objects and one list box i.e. Hierarchy calendar
And The 4 text object Expressions are like this way:
Text object1 : =Count({<Recruiter={'Irfan','Ranjan','Saxena','Singh'}>}CandidateID) and this will relationship with master calendar and plc date column
Text object2 : =Count({<Recruiter={'Irfan','Ranjan','Saxena','Singh'}>}CandidateID) and this will relationship with master calendar and offer date column
Text object3 : =Count({<Recruiter={'Irfan','Ranjan','Saxena','Singh'}>}CandidateID) and this will relationship with master calendar and Decline date column
Text object4 : =Count({<Recruiter={'Irfan','Ranjan','Saxena','Singh'}>}CandidateID) and this will relationship with master calendar and JobEnd date column
How to do that can you guys help me,
And I asked my PowerBI Team also, They Implemented like this:
for text object1:
Placed =
CALCULATE (
Count (PlacementDate[CandidateID] ),
USERELATIONSHIP (
PlacementDate[plcdate],
'Calendar'[Date]
)
)
for text object2:
Placed =
CALCULATE (
Count (PlacementDate[CandidateID] ),
USERELATIONSHIP (
PlacementDate[Offerdate],
'Calendar'[Date]
)
)
.......... like this
Note: PlacementDate, Calendar are Table Names...., CandidateID,plcdate,date are Column Names
And the out came correctly for all of them
But we want to implement it Qlikview or Qliksense.
I think now you people got the clarity on requirement
Hi Priyal,
Here, I am attaching again... and see my latest reply also I gave my requirement clearly.
Thank you in advance
Hi,
Use resident load and concatenation having the date field as the same column names as in master calender.
a:
Load
field1,
field2
datefield1 as DATE_FILELD,
datefield2,
datefield3,
datefield4
from qvd;
concatenate(a)
load
datefield2 as DATE_FILELD
resident a;
concatenate(a)
load
datefield3 as DATE_FILELD
resident a;
concatenate(a)
load
datefield4as DATE_FILELD
resident a;
Link this DATE_FILELD with master calender
Hi priyalvp24,
How to link with master calendar, Can you Please Explain me.
If possible can you please do with my qvd & qvw
I tried So many ways but when i am trying to create text objects i am not able to get the correct answer
will send you the qvf
Thank you in advance,
I will wait for your qvf
Guys can you please help me out from this