Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bvssudhakar
Creator III
Creator III

Link with Master Calendar

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

28 Replies
priyalvp24
Creator
Creator

Kindly send the qvf

bvssudhakar
Creator III
Creator III
Author

Hi Priyal

I already attached qvd file with the discussion. Please find and help me out from this

priyalvp24
Creator
Creator

Not able to find it,please resend it

bvssudhakar
Creator III
Creator III
Author

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


bvssudhakar
Creator III
Creator III
Author

Hi Priyal,

Here, I am attaching again... and see my latest reply also I gave my requirement clearly.

Thank you in advance

priyalvp24
Creator
Creator

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

bvssudhakar
Creator III
Creator III
Author

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

priyalvp24
Creator
Creator

will send you the qvf

bvssudhakar
Creator III
Creator III
Author

Thank you in advance,

I will wait for your qvf

bvssudhakar
Creator III
Creator III
Author

petter-smarcowedel

Guys can you please help me out from this