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

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Gartner® Magic Quadrant™: 15 YEARS A LEADER - GET THE REPORT
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2015-09-10 08:35 AM

Problem with designing dimensions

I have a table named OC which contained OCCode , start date , end date  .

I need to use this dismension two times as filter  :

  • First I need to add OC and in order to get the following result :

when I choose OCC111 as OCCode,   I should get CA total for all OCbetween the start date and the end date for OCC111 .

  • Another filter for the dimension OC when I choose OCC111 as OCCode I should get CA total only for OCC111 between the start date and the end 

How to design it in qlikview ? This is what I tried :

Sans titre.png

414 Views
0 Likes
0 Replies