Stack Bar Chart - 100% Stack Bar Chart

[ishanbansal1204]

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

[ishanbansal1204]

Will this work in Qlik sense as well?

[sunny_talwar · Accepted solution]

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]

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