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: 
madhur4qlik
Partner - Contributor III
Partner - Contributor III

Need bucketting Logic to be created in Calculated Dimension of Pivot table

Hi

I need little help here. I have below two columns coming from DB. Third column I m creating as (100/percentile) and than I have to bucket it as if col3 <5 then B1 else if col3 > 5 and < 10 than B2 else B3

PercentileBand
80-10
90-10
1510-20
1710-20
3430-40
4840-50
6560-70
9590-100

n trying to get below table

   

PercentileBand ABand BCal
80-10B312.5
90-10B311.11111
1510-20B26.666667
1710-20B25.882353
3430-40B12.941176
4840-50B22.083333
6560-70B11.538462
9590-100B11.052632

I have achieve end result as below mentioned cross tab where we have to show how many value of  "Cal' values will fall the intersection of column Band A and Band B

NOTE: I am struggle to create a buckets of B1 B2 B3 in chart pivot table ... this has to be done in chart level only not on script level

cross tab as below table. Values in measure cells indicate the occurrence

 

0-1010-2030-4040-5060-7080-9090-100
B1 1 1 1
B2 2 1
B32
1 Solution
6 Replies
Anonymous
Not applicable

Hi Madhur,

Please Find the Attached QVW.

1.PNG

If you want to show in Pivot Table, Then Top Chat will help you, but there is no way to hide the first column in pivot table, Below chart shows the same data pivoted in straight table, you can hide column class.

Hope this will help you solving the problem.

Thanks

Mouna Chandra

madhur4qlik
Partner - Contributor III
Partner - Contributor III
Author

Hi Mouna,

Thanks for th reply. But i dont see any attached QVW here. Could you please attach the same.

Thanks

Madhur

Anonymous
Not applicable

Hi i am sorry but i am seeing the attachment, Please open the full thread in a separate window, and you will find the attachment.

thanks

mouna chandra

madhur4qlik
Partner - Contributor III
Partner - Contributor III
Author

Hi Mouna,

thanks for the help.

Actually my bad, now i can see the qvw.

The tried to present the issue in a very simple way as this is one part of complex requirement.

Actually the calculation 100/percentile i am calculating through a set analysis formula so the bucketing needs to be done in chart dimension only not in script.

I apologize .. if i am missing something here as i am just 1 few months old in qlikview.

Would be great if you can let me know what how i can bucket the 100/percentile in chart.

madhur4qlik
Partner - Contributor III
Partner - Contributor III
Author

Thanks Bala For the help. It worked.