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: 
ishanbansal1204
Contributor III
Contributor III

Stack Bar Chart - 100% Stack Bar Chart

Hi Experts,

Facing a scenario where in i am getting the values in the form of stack bar chart but i want to show that in the form of 100% stack bar chart.

Dimensions - Week and Category

Category has the formula -

IF (Aggr(Sum(AMOUNT_CLIENT), [CLIENTNUMBER],[YEAR],[WEEK]) < 10, 'Low Spender',

IF (Aggr(Sum(AMOUNT_CLIENT), [CLIENTNUMBER],[YEAR],[WEEK]) >= 10 AND Aggr(Sum(AMOUNT_CLIENT), [CLIENTNUMBER],[YEAR],[WEEK]) <25, 'Average Spender',

IF (Aggr(Sum(AMOUNT_CLIENT), [CLIENTNUMBER],[YEAR],[WEEK]) >= 25 AND Aggr(Sum(AMOUNT_CLIENT), [CLIENTNUMBER],[YEAR],[WEEK]) <50, 'Hign Spender',' Very Hign Spender')))

Measure is Count(DISTINCT [CLIENTNUMBER])

These are basically categorized in Bucketing system.

If you need any more details let me know.

Thanks

Message was edited by: Ishan Kumar

13 Replies
ishanbansal1204
Contributor III
Contributor III
Author

Will this work in Qlik sense as well?

sunny_talwar

I don't see a reason why it won't.

Dimension

WEEK

IF (Aggr(Sum(AMOUNT_CLIENT), [CLIENTNUMBER],[YEAR],[WEEK]) < 10, 'Low Spender',

IF (Aggr(Sum(AMOUNT_CLIENT), [CLIENTNUMBER],[YEAR],[WEEK]) >= 10 AND Aggr(Sum(AMOUNT_CLIENT), [CLIENTNUMBER],[YEAR],[WEEK]) <25, 'Average Spender',

IF (Aggr(Sum(AMOUNT_CLIENT), [CLIENTNUMBER],[YEAR],[WEEK]) >= 25 AND Aggr(Sum(AMOUNT_CLIENT), [CLIENTNUMBER],[YEAR],[WEEK]) <50, 'Hign Spender',' Very Hign Spender')))

Expression

Count(DISTINCT [CLIENTNUMBER])/Avg(Aggr(NODISTINCT Count(DISTINCT [CLIENTNUMBER]), WEEK))

ishanbansal1204
Contributor III
Contributor III
Author

Thank you Sunny.

Really appreciate your help.

Thank you again

sunny_talwar

No problem at all. Let us know how it goes in Qlik Sense.

Best,

Sunny