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: 
yogitamehta10
Creator
Creator

drill down dimension

Hi All,

Could you Plaese help me in resolving this issue , i'm using qliskense, i have a drill down dimesion

first dimension:status two values - Accepted, Rejected

second dimension : failure occurance

calculate dimension i'm using

If(IsNull(FAILURE_OCCURENCE),'Attempt 1'

,if(FAILURE_OCCURENCE='1','Attempt 2',if(FAILURE_OCCURENCE='2','Attempt 3',

if(FAILURE_OCCURENCE='3','Attempt 4',if(FAILURE_OCCURENCE='4','Attempt 5',if(FAILURE_OCCURENCE >'4','Attempt 5+'))))))

my conecrn is when i qlik on accpeted ,  it should show  values related of accepted txn for second diemnsion

and when i qlik on rejected  it should show values of rejected occurrence , but as of now it is showing total value while clicking on accepted and rejected , both are showing same value.

any workaround for this ?

3 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Its difficult to diagnose the problem based on the information provided. More information about your data model would greatly assist in providing useful advice.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
yogitamehta10
Creator
Creator
Author

see i have this table that has two colmuns

status , occur an

values are like this , just a simple  table

STATUS FAILURE_OCCURENCE

Accepted 1

Accepted 2

Accepted 1

Accepted 1

Accepted 1

Accepted 1

Inactive 1

Accepted 1

Inactive 1

Accepted 2

Accepted 1

Accepted 1

Inactive 1

Accepted 1

Accepted 1

Accepted 1

Rejected 1

Accepted 1

Inactive 1

Accepted 1

Accepted 1

Accepted 1

Accepted 1

Accepted 1

Rejected 2

Accepted 1

Rejected 2

Accepted 1

Rejected 1

Accepted 1

Accepted 1

Rejected 1

Accepted 1

Accepted 2

Accepted 1

Accepted 1

Accepted 1

Accepted 1

Inactive 1

Accepted 1

Inactive 1

Accepted 2

Accepted 1

Accepted 1

Inactive 1

Accepted 1

Accepted 1

Accepted 1

Accepted 1

Accepted 1

Rejected 2

Accepted 1

Rejected 2

Rejected 1

Accepted 1

Inactive 1

Accepted 1

Accepted 1

Rejected 1

Accepted 2

now i want if in pie chart i qlik on accepted then it will tell me occurance count of   accpeted  and if i click on rejected then it qill show me the count of rejcted

yogitamehta10
Creator
Creator
Author

Please sugegst something , its kind of little urgent..