Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
vijay2
Contributor II
Contributor II

Viewing multiple dates in pivot table

Hello guys,

I want to be able to see two dates (createddate and applicationdate) on the below table as certain fields depend on either.
For example: Billable Inbounds depends on createddate while Distinct Policy Count depends on application date.

I am using valuelist() function for each of these fields. 

Billable Inbounds
count({$<createddate={">=$(=FirstWorkDate(Today(), 7))"}>} distinct If(ValueList('Billable Inbounds',Distinct Policy Count')='Billable Inbounds', token,null()))

Distinct Policy Count:
count({$<application_date={">=$(=FirstWorkDate(Today(), 7))"}>} distinct If(ValueList('Billable Inbounds',Distinct Policy Count')='Distinct Policy Count', Product&policy_id,null()))

 

Please help.

 

vijay2_0-1625694358290.png

 

Labels (1)
0 Replies