topic Re: Straight Table with Two Columns in QlikView

Straight Table with Two Columns

jmonroe918 — Thu, 26 Oct 2017 03:00:06 GMT

Trying to create a straight table that displays data by Site (per Row) and Age Buckets (Columns) See below:

Site 180 - 365 >365

VST 2 1

TJM 1 2

AUS 0 4

My Data is as follows:

Site CA No Age

VST 100 200

VST 101 300

AUS 102 366

TJM 103 190

TJM 104 390

VST 105 400

TJM 106 445

AUS 107 370

AUS 108 480

AUS 109 367

I am creating the Age Buckets in my dimensions with an if statement (=if([CA No] < 365, '180 - 365', '> 365') along with Site. I can't get the Age Bucket out of the rows and into two columns.

Thanks

Jeff

Re: Straight Table with Two Columns

Anil_Babu_Samineni — Thu, 26 Oct 2017 03:13:33 GMT

PFA

Re: Straight Table with Two Columns

devarasu07 — Thu, 26 Oct 2017 03:17:18 GMT

Hi,

you if condition should be Age instead of "CA No" and the to show the age_bucket calculated column do transformation row-into column using pivot chart object.

Data:

load *,if(Age<365, '180 - 365', '> 365') as AgeBuckets;

LOAD * INLINE [

Site, CA No, Age

VST, 100, 200

VST, 101, 300

AUS, 102, 366

TJM, 103, 190

TJM, 104, 390

VST, 105, 400

TJM, 106, 445

AUS, 107, 370

AUS, 108, 480

AUS, 109, 367

];