Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Re: Link with Master Calendar

Kindly send the qvf

Highlighted
Creator II
Creator II

Re: Link with Master Calendar

Hi Priyal

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

Highlighted
Creator
Creator

Re: Link with Master Calendar

Not able to find it,please resend it

Highlighted
Creator II
Creator II

Re: Link with Master Calendar

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


Highlighted
Creator II
Creator II

Re: Link with Master Calendar

Hi Priyal,

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

Thank you in advance

Highlighted
Creator
Creator

Re: Link with Master Calendar

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

Highlighted
Creator II
Creator II

Re: Link with Master Calendar

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

Highlighted
Creator
Creator

Re: Link with Master Calendar

will send you the qvf

Highlighted
Creator II
Creator II

Re: Link with Master Calendar

Thank you in advance,

I will wait for your qvf

Highlighted
Creator II
Creator II

Re: Link with Master Calendar

petter-smarcowedel

Guys can you please help me out from this