Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Pivot Table : Row and Column same field

Hi there,

In my pivot table matrix report. three fields in use -

"Risk Model Execution Id"

"As At Dt"

"Risk Result Band"

I need to create a report where I can compare two "Risk Model Execution Id"  ,"As At Dt" with "Risk Result Band" like below image1

 

image1

 

Capture.PNG

 

If I select "Risk Model Execution Id" 60  then "As At Dt" needs to come "15/09/2020" and displayed at Row level and Column level will be one the selected field on the other filter (using the same "Risk Model Execution Id")

Capture3.PNG

 

Can this be done without changing the script of the model .?

 

Thanks

0 Replies