topic Re: Drilling down and stack in a bar chart based on columns in QlikView

Drilling down and stack in a bar chart based on columns

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a Bar chart, which is made from 3 columns. The columns are being fetched from two db tables that are connected using ODBC.

Now in the dimensions I have the similar field in both the tables that is sku. Kindly see the screenshots for better understanding

Now the problem is that I want the comparison between TV1 and TV2 and the SKu's of both as stacks. Also The moment some person clicks on the sku1 it should drill down into remotes . Please help

Re: Drilling down and stack in a bar chart based on columns

YoussefBelloum — Thu, 08 Feb 2018 09:32:17 GMT

Hi,

did you try to do it and it is not working or you don't know how to do it ?

can you share the expressions used ? or can you you share a QVW test ?

Re: Drilling down and stack in a bar chart based on columns

Anonymous — Thu, 08 Feb 2018 09:36:51 GMT

I tried quite a lot of things, I don't have license so that is why I didn't share it. Also I'm new to qlikview so I'm not sure if i'm going the right way. The Dimensions are Sku, and the expressions are sum(TV1) and Sum(TV2). It tried grouping in the edit group option and then adding it but it was throwing all the data at once, rather than giving me a chance to click and make selection.

Re: Drilling down and stack in a bar chart based on columns

hanstorsvik — Thu, 08 Feb 2018 09:57:39 GMT

If you create you QVW with the "Personal Edition"-license others that do have a license can still open the file. So do share it...

You might consider to model your data a little bit further.

But with the datamodel at hand...

In order for the graph to drill into the data you must define it.
It is in a diffrent column and thus need a diffrent expression...

So add two more expressions. One for Remote1 and one for Remote2.
Then in the conditional expression, only show TV expressions when possibe Sku's are > 1 and show Remote expressions when possible Sku's = 1...

Hans

Re: Drilling down and stack in a bar chart based on columns

YoussefBelloum — Thu, 08 Feb 2018 10:04:24 GMT

Hi,

find attached.

here is the expressions i used for the first view (TV):

=sum({<sku=>}TV1) => TV1

=sum({<sku=>}TV2) => TV2

=sum({<sku=>}TV2)-sum({<sku=>}TV1) => difference

on each of these expressions, enable conditional display and put this:

GetSelectedCount(sku)=0

here is the expressions i used for the first view (Remote):

=sum({<sku=>}Remote1) => Remote1

=sum({<sku=>}Remote2) => Remote2

=sum({<sku=>}Remote1)-sum({<sku=>}Remote2) => difference

on each of these expressions, enable conditional display and put this:

GetSelectedCount(sku)<>0

add a filter object SKU and try choosing an SKU, you will see that as soon as you choose one, the bar charts move to the Remote View.

if you can't open the app, you can download file 1 and 2, it is your data.

juste create the object and use everything I described above.

Re: Drilling down and stack in a bar chart based on columns

Anonymous — Fri, 09 Feb 2018 06:46:17 GMT

It partially worked, I still didn't get the TV comparison, but had them stacked over one another.

I didn't try for remote, because just the TV part is not working. Could you please check, and let me know where I'm going wrong

Re: Drilling down and stack in a bar chart based on columns

Anonymous — Fri, 09 Feb 2018 06:50:38 GMT

Could you explain model your data part. I didn't understand what you meant there. Also, could you tell me how to upload the qvw file. And could you elaborate a bit on the expressions part a bit more.

Re: Drilling down and stack in a bar chart based on columns

YoussefBelloum — Fri, 09 Feb 2018 17:01:51 GMT

I thought you need the difference as a third stacked measure...

what do you need for the differences ??

Re: Drilling down and stack in a bar chart based on columns

Anonymous — Tue, 13 Feb 2018 11:54:05 GMT

Actually I meant a side by side comparison of TV1 and TV2 where in the stacks sku1, sku2, sku3 should appear rather than TV1 and TV2. Hopefully this clears out the confusion