topic Re: Remove bars with values higher or lower than in QlikView

Remove bars with values higher or lower than

YoussefBelloum — Sat, 16 Nov 2024 18:02:58 GMT

Hi guys, hope you're doing well !

Please find below a data sample

année trimestre chiffre
2017 T4 100
2017 T3 300
2017 T2 500
2017 T1 800
2018 T1 150
2018 T2 350
2018 T3 900
2018 T4 1000
2019 T1 500
2019 T4 710
2019 T3 760
2019 T2 990

Example: I'm trying to get a barchart for the amounts >= 800 and remove the blank spaces corresponding to the rest of the quarters, the result I need is the 2nd barchart below (I did it with paint)

Dimensions are : année, trimestre

Measure: sum({<chiffre={">=800"}>}chiffre)

I can't make it work with a set analysis or If on the dimensions...

Can you please take a look ?

Thank you

Youssef

Re: Remove bars with values higher or lower than

edwin — Mon, 28 Sep 2020 18:05:20 GMT

Hi, your expression is actually correct

the reason you have spaces in between the years is you are missing data for trimester. how did you want it to render?

Re: Remove bars with values higher or lower than

YoussefBelloum — Mon, 28 Sep 2020 19:23:23 GMT

Yes, data is missing because it is not corresponding to the condition on my set analysis.

like I said, i want it to render like my second barchart, on the image attached on the post.

thanks

Re: Remove bars with values higher or lower than

edwin — Mon, 28 Sep 2020 20:50:19 GMT

if you use GROUPED as your style, QV will ALWAYS render a space for a dimension with 0 value.

if you select STACKED then anything that is 0 will not render:

Re: Remove bars with values higher or lower than

YoussefBelloum — Tue, 29 Sep 2020 00:22:17 GMT

I need to keep the barchart style normal, every quarter of every year on a distinct bar. Is there a back end or front end solution to get the chart that I poster above ?

Re: Remove bars with values higher or lower than

YoussefBelloum — Tue, 29 Sep 2020 10:11:27 GMT

@sunny_talwar @kaushiknsolanki @Kushal_Chawda

would you be able to take a look please ?

Re: Remove bars with values higher or lower than

Taoufiq_Zarra — Tue, 29 Sep 2020 11:11:43 GMT

@YoussefBelloum I don't think that's possible, you can check this discussion.

mais sinon si 800 est toujours fixe je pense qu'au niveau du load script tu peux créer une autre table dont il figure que les trimestres et année avec sum(..) >800 !

Re: Remove bars with values higher or lower than

YoussefBelloum — Tue, 29 Sep 2020 11:19:08 GMT

It seems that what I want to acheive it can't be done on a barchart with two dimensions, some members asked the same question, still not been solved.

The solution that I find is to replace my two dimensions (quarter and year) with only one "Quarter-Year" dimension. it works now.

If a solution exists, I'll be happy to see you share it here

Thank you all.

Re: Remove bars with values higher or lower than

YoussefBelloum — Tue, 29 Sep 2020 13:23:56 GMT

Hi @Taoufiq_Zarra

concatenating a new portion to my table filtering on amount greater or less, can be a solution. unfortunately it is not the best suited to my data-model and to the graphics tabs that are already developed.

Like I said below, the front-end solution was to concatenate fields year and quarter into one dimension.

Youssef