Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Its difficult to diagnose the problem based on the information provided. More information about your data model would greatly assist in providing useful advice.
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
Please sugegst something , its kind of little urgent..