Need Help

[qv_testing]

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...

[MarcoWedel]

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

[qv_testing]

Thank You Petter....