topic Help trying to create chart in QlikView

Help trying to create chart

hopkinsc — Thu, 18 Jun 2015 10:14:40 GMT

Hi All,

Is there a way i can create a chart that looks like the following?

i want to see the values by the different timeframes in the same chart if possible..

I have attached a qvw with the above data in.

Can someone help please?

Re: Help trying to create chart

sunny_talwar — Thu, 18 Jun 2015 10:27:22 GMT

I don't think the options available within QV will allow you to do something like this, but as a work around you can place three straight tables next to each other make them look like as if they are one table. Not sure if that will work for you?

Re: Help trying to create chart

buzzy996 — Thu, 18 Jun 2015 10:29:34 GMT

see tis,

Re: Help trying to create chart

sunny_talwar — Thu, 18 Jun 2015 10:30:48 GMT

See if the attached image (work around) looks good

Re: Help trying to create chart

sunny_talwar — Thu, 18 Jun 2015 10:33:07 GMT

With correct sorting:

Re: Help trying to create chart

avinashelite — Thu, 18 Jun 2015 10:34:22 GMT

In Qlikview we don't have a option to build such a kind of representation, try with the Pivot table that would yield almost similar result. You can try with other ways too but keep in mind it will be always static and if the number of data changes then the position of the static object won't change

Re: Help trying to create chart

avinashelite — Thu, 18 Jun 2015 10:38:24 GMT

sunindia‌ bro nice work ...but this will fail when user tries to export the data and if user selects some filter then it might fail .

Re: Help trying to create chart

sunny_talwar — Thu, 18 Jun 2015 10:41:20 GMT

‌Agreed Avinash ... But that is why I called it a work around... You are right, may be Pivot table might be able to get him the result... but will have to play around with it a little

Re: Help trying to create chart

Thu, 18 Jun 2015 10:43:56 GMT

Hi Sunindia,

Kindly help me resolve the following query using the SCD solution

Well, I have the following Inline table

LOAD * INLINE

[

Product, ProdName, Price, Updated

123, Watch, 150$, 1/1/2015

134, Fruit, 30$, 1/1/2015

145, Ring, 3000$, 3/1/2015

123, Watch, 125$, 5/1/2015

123, Watch, 119$, 5/5/2015

134, Fruit , 50$, 5/5/2015

145, Ring, 2500$, 5/12/2015

234, Pen, 12$, 5/17/2015

312, Jeans, 50$, 6/9/2015

];

Using the above input table, I need to get the below reults


Product	ProdName	Price	Updated	From	To Date
123	Watch	150$	1/1/2015	1/1/2015	4/30/2015
123	Watch	125$	5/1/2015	5/1/2015	5/42015
123	Watch	119$	5/5/2015	5/5/2015	6/18/2015

Help me implementing the same.

Thanks in advance

Re: Help trying to create chart

hopkinsc — Thu, 18 Jun 2015 10:49:23 GMT

Thanks for all of the replies.

I actually tried separate charts before posting here. it looks ok but one of the requirements is that the user can make a selection on Month, QTR or half year to see a breakdown of the sales at Department level in another table. the problem with charts is that once a selection is made the chart hides all grey values therefore it will go smaller which will then mean that the 3 charts are different sizes.

I have also tried a pivot table but i can't get the expression to show below each of the pivoted dimensions.

Re: Help trying to create chart

avinashelite — Thu, 18 Jun 2015 11:03:53 GMT

the exact representation we cannot achieve in Qlikview

Re: Help trying to create chart

hopkinsc — Thu, 18 Jun 2015 11:06:52 GMT

thats what i thought but thought i would ask the question. thanks everyone

Re: Help trying to create chart

sunny_talwar — Thu, 18 Jun 2015 11:18:22 GMT

Created these using pivot table, does one of them help you achieve what you wanted?

Best,

Sunny

Re: Help trying to create chart

sunny_talwar — Thu, 18 Jun 2015 11:20:34 GMT

Unfortunately, this is the closest you will be able to get to what you want

HTH

Best,

Sunny

Re: Help trying to create chart

sunny_talwar — Thu, 18 Jun 2015 11:22:15 GMT

Hi Ruchi -

I think you should start a new thread for your requirement so that others including me can help you. Posting in someone else's post is generally not a good idea. If you have posted your question somewhere, I would rather respond to you there then here.

I hope it make sense?

Best,

Sunny

Re: Help trying to create chart

Thu, 18 Jun 2015 11:32:19 GMT

Hi Sunindia,

It does makes sense. I am just new to QV and this forum so didnt knew the rules of it. Thanks

Re: Help trying to create chart

sunny_talwar — Thu, 18 Jun 2015 11:33:48 GMT

Not a problem

I am glad you already did what I asked and got responses from some really smart experts, so it all worked out well for you.

Best,

Sunny

Re: Help trying to create chart

hopkinsc — Thu, 18 Jun 2015 14:05:24 GMT

Hi Sunindia, thanks, i used the last example you gave. it was almost what they wanted

Re: Help trying to create chart

sunny_talwar — Thu, 18 Jun 2015 14:08:53 GMT

Awesome

I am glad we got close enough to what the user wanted.

Best,

Sunny