Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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

1 Solution

Accepted Solutions
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))

View solution in original post

13 Replies
sunny_talwar

May be try this:

Count(DISTINCT [CLIENTNUMBER])/Count(TOTAL <Week> DISTINCT [CLIENTNUMBER])

ishanbansal1204
Contributor III
Contributor III
Author

Hi Sunny,

I go the values as 400%

may be because i have bucketing involved in this?

ishanbansal1204
Contributor III
Contributor III
Author

Hi Sunny,

It is showing me as 400%.

have checked but the values are not right.

we have bucketing as part of my dimension and i feel that might be creating a problem.

ishanbansal1204
Contributor III
Contributor III
Author

Not Working..

Its showing me in the form of 400%

I think i am using bucketing here so it is taking 100% each for bucketing.

Please suggest further.

sunny_talwar

Can you share a sample?

rupamjyotidas
Specialist
Specialist

Taking help of Sunny Equation here

this will group it more detailed

Count(DISTINCT [CLIENTNUMBER])/Count(TOTAL <Year,Week> DISTINCT [CLIENTNUMBER])

ishanbansal1204
Contributor III
Contributor III
Author

Hi Sunny,

I have attached the sample in the start Bucketing.csv

Please let me know the solution for it.

sunny_talwar

See if this is what you wanted Ishan

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

Capture.PNG

ishanbansal1204
Contributor III
Contributor III
Author

Hi Sunny,

Yes this is what i wanted.

How did you achieve this?

What should be in the dimension and measure?