topic Re: Need Help in QlikView

Need Help

Nagaraju_KCS — Wed, 16 Sep 2015 04:20:57 GMT

Hi All,

I have one requirement..

I have 3 bucket in my table,

Field1 Field2 Field3

0-10 - 0-10

10-20 10-20 10-20

20-30 20-30 20-30

30-40 - 30-40

- 40-50 -

- 50-60 -

I want to show bucket wise count in Stacked bars...

Suppose i have 0-10 i want show in stacked bar only related 0-10 for three fields count(Field1, Field2 and Field3).

My X-Axis should be 0-10, 10-20, 20-30, 30-40,40-50,50-60

and stacked BAR (Suppose 0-10, here i have to show only Filed1 and Field3 count in my Bar.. because Field2 0-10 i don't have in my bucket )

My output should be like this...and so on .... like 30-40,40-50,50-60

Thanks in Advance...

Re: Need Help

jonathandienst — Wed, 16 Sep 2015 05:05:57 GMT

I have no idea what you are trying to do. I suggest that you post a sample qvw with representative data and more detail about exactly what you want to create. Screenshots are of very limited value.

Re: Need Help

marcus_sommer — Wed, 16 Sep 2015 05:14:32 GMT

I think you will rather need another data-structure which looks like:

ClusterSize Amount

0-10 n

10-20 n

....

transformed per crosstable-load: The Crosstable Load

- Marcus

Re: Need Help

petter — Wed, 16 Sep 2015 05:19:43 GMT

Is it something like this you are looking for:

Re: Need Help

Nagaraju_KCS — Wed, 16 Sep 2015 06:11:50 GMT

Hi Petter,

I am sorry, I am confusing with how to explain my requirement..

Example:

I have one table, 2 buckets.

Like Bucket1 and Bucket2

Suppose Bucket1=0-10, 10-20, 30-40

Bucket2=10-20,20-30,30-40,50-60

Now, Barchart dimension should be in X-Axis

i want to show 0-10,10-20,20-30,30-40,50-60

I want to show Stacked bar..

Suppose 0-10 bar i want to show count only (0-10 Bucket1 count and 0-10 Bucket2 count)

Now Hope you Understand...

Re: Need Help

Nagaraju_KCS — Wed, 16 Sep 2015 17:28:40 GMT

Please anyone help me.............

Re: Need Help

petter — Wed, 16 Sep 2015 18:36:22 GMT

Re: Need Help

Nagaraju_KCS — Wed, 16 Sep 2015 18:52:47 GMT

HI Petter,

PFA,

Re: Need Help

petter — Wed, 16 Sep 2015 19:35:20 GMT

What does the data in your table mean? What is Mtng_Time_Bucket and what is TIME_Bucket?

Re: Need Help

petter — Wed, 16 Sep 2015 20:00:44 GMT

I think I finally got it ... have a look:

Had do do a CROSSTABLE(....) LOAD to get the data in a table format that would work for me:

Re: Need Help

MarcoWedel — Wed, 16 Sep 2015 21:28:33 GMT

Hi,

maybe you could keep your original table and create another bucket table using a crosstable load like already suggested by Petter and Marcus:

BINARY https://community.qlik.com/servlet/JiveServlet/download/867893-185198/Sample_1057.qvw;

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

tabBuckets:
CrossTable ([Time Type], Time)
LOAD PK,
    Mtng_Time_Bucket,
    TIME_Bucket
Resident MAIN;

If there are more buckets in your productive data (10+ weeks) you should also consider loading the bucket as a dual value for sorting purposes.

hope this helps

regards

Marco

Re: Need Help

Nagaraju_KCS — Thu, 17 Sep 2015 03:07:32 GMT

Thank You Petter....