topic Re: need to create Bar chart but by manipulating data in Visualization and Usability

need to create Bar chart but by manipulating data

ha142000 — Fri, 15 Nov 2024 21:32:47 GMT

hi i have this data

where I have company name and Product count made by them

I Need to get this data In this form

And Create bar chart for it ,Details in X axis and Countss in Y axis in Bar chart

.Can any one help me with it

Re: need to create Bar chart but by manipulating data

rubenmarin — Sat, 10 Jun 2023 07:27:00 GMT

Hi, you can use a calculated dimension like:

=ValueList('Dim1','Dim2','Dim3'...)

And the expression can check the var as:

Pick(Match(ValueList('Dim1','Dim2','Dim3','Dim4'),'Dim1','Dim2','Dim3','Dim4')
,Count({<Product={1}>}Company)
,Count({<Product={">1<=3"}>}Company)
,Count({<Product={">3<=9"}>}Company)

,Count({<Product={">9"}>}Company)
)

Re: need to create Bar chart but by manipulating data

ha142000 — Tue, 13 Jun 2023 09:57:18 GMT

hi ,I need to use valuelist in barchart or in load editor

Re: need to create Bar chart but by manipulating data

rubenmarin — Tue, 13 Jun 2023 10:00:13 GMT

valuelist is a chart only function.

Use it in a calculated dimension (a dimension that has an expression, not only a field) and in the measure like in the example above.

Re: need to create Bar chart but by manipulating data

ha142000 — Tue, 13 Jun 2023 11:59:14 GMT

thanks alot it worked

Re: need to create Bar chart but by manipulating data

NiTo — Wed, 14 Jun 2023 14:35:45 GMT

Hello Rubenmarin,

I tried the expression but m getting an error: Error in expression: ')' is expected.

I did not made any change to the expression othen than chaning the name of fields.

Help Plz.

Thanks

Re: need to create Bar chart but by manipulating data

NiTo — Wed, 14 Jun 2023 14:39:15 GMT

Here is the expression that I used.

Pick(Match(ValueList('UniqueCompany','CompanyProduct>3','CompanyProdcutsBetween 3 and 9','CompanyProduct>9'),
'UniqueCompany','CompanyProduct>3','CompanyProdcutsBetween 3 and 9','CompanyProduct>9')
,Count({<[Product Count]={1}>}(UniqueCompany))
,Count({<[Product Count]={">1<=3"}>}(CompanyProduct>3))
,Count({<[Product Count]={">3<=9"}>}(CompanyProdcutsBetween 3 and 9))
,Count({<[Product Count]={">9"}>}(CompanyProduct>9))
)

Re: need to create Bar chart but by manipulating data

rubenmarin — Wed, 14 Jun 2023 14:44:33 GMT

Hi, the count should be on the company name field

Pick(Match(ValueList('UniqueCompany','CompanyProduct>3','CompanyProdcutsBetween 3 and 9','CompanyProduct>9'), 'UniqueCompany','CompanyProduct>3','CompanyProdcutsBetween 3 and 9','CompanyProduct>9') ,Count({<[Product Count]={1}>}CompanyNameField) ,Count({<[Product Count]={">1<=3"}>}CompanyNameField) ,Count({<[Product Count]={">3<=9"}>}CompanyNameField) ,Count({<[Product Count]={">9"}>}CompanyNameField) )

And [Product Count] should be the field that stores the number of products of each company

Re: need to create Bar chart but by manipulating data

NiTo — Wed, 14 Jun 2023 15:34:16 GMT

Hello Rubenmarin.

Thanks for your reply. I made the changs and yes it works. I got the count of products depending upon the classification.

But, I am not getting the total of all the counts, on the top of the column, as u can see in the image attached.

Any suggestion. I am new to qlik sense, so I have got a lots of questions.

Thanks

Re: need to create Bar chart but by manipulating data

rubenmarin — Wed, 14 Jun 2023 15:41:36 GMT

Hi, in the measure three is an option to enable/disable the total row, when enabled there is another option to select the totals formula, instead of 'Automatic' select 'Sum'.

Re: need to create Bar chart but by manipulating data

NiTo — Wed, 14 Jun 2023 15:49:50 GMT

Thank you so much. I got it.

One more thing, I want to know, if it is not too much of trouble.

I am trying to get a QSDA certification and I just started practicing. What is the best way to go about it? I am watching online videos. For more complex issues, I check the community, pick up a random issue, making a table in excel and then working on it, just like it did here.

Any suggestion? I wil be really grateful.

Regards,

Thanks

Re: need to create Bar chart but by manipulating data

rubenmarin — Thu, 15 Jun 2023 06:10:11 GMT

Hi Nito, the best way is to have enough experience with real problems solved, solving questions in the community is also a good way. For QSDA it's important to know how to solve data model issues, like using the concatenation of fact tables or the use of composite keys to avoid circular references.

I don't have much to say, I think you're taking a good way to increase your knowledge.

Good luck!... and keeping practice is a good way to increase your luck.😉

Re: need to create Bar chart but by manipulating data

NiTo — Thu, 15 Jun 2023 06:44:18 GMT

Hi RubenMarin and thanks for the encouraging words.

Good day to you.