topic Re: Pivot or Straight table without expression in QlikView

Pivot or Straight table without expression

clovati — Wed, 29 Jun 2016 13:45:01 GMT

Hi all!

I have QVD like first image and want to have the right structure in QlikView.

Any suggestion on how to do it? thanks a lot!

Re: Pivot or Straight table without expression

settu_periasamy — Wed, 29 Jun 2016 17:49:57 GMT

Hi,

without expression? you mean like a table box? if so, you need to do it in script.

we can do it in both charts with using 'only' function.

sample attached

Re: Pivot or Straight table without expression

maxgro — Wed, 29 Jun 2016 20:11:53 GMT

in script

SET DateFormat='M/D/YYYY';

LOAD * INLINE [

shop, Day, Color, Status

shop1, 1/1/2016, Red, Yes

shop2, 1/2/2016, Red, Yes

shop3, 1/3/2016, Red, No

shop4, 1/4/2016, Red, No

shop5, 1/5/2016, Red, Yes

shop6, 1/6/2016, Red, Yes

shop1, 1/1/2016, Green, No

shop2, 1/2/2016, Green, No

shop3, 1/3/2016, Green, Yes

shop4, 1/4/2016, Green, Yes

shop5, 1/5/2016, Green, No

shop6, 1/6/2016, Green, No

shop1, 1/1/2016, Yellow, Yes

shop2, 1/2/2016, Yellow, Yes

shop3, 1/3/2016, Yellow, No

shop4, 1/4/2016, Yellow, No

shop5, 1/5/2016, Yellow, Yes

shop6, 1/6/2016, Yellow, Yes

];

NoConcatenate LOAD shop, Day, Status as Red Resident S Where Color = 'Red';

join (T) LOAD shop, Day, Status as Green Resident S Where Color = 'Green';

join (T) LOAD shop, Day, Status as Yellow Resident S Where Color = 'Yellow';

DROP Table S;

Re: Pivot or Straight table without expression

rwunderlich — Wed, 29 Jun 2016 20:26:23 GMT

I would use the Generic Load.

SET DateFormat='M/D/YYYY';

Data:

LOAD *, shop & Day as RecId INLINE [

shop, Day, Color, Status

shop1, 1/1/2016, Red, Yes

shop2, 1/2/2016, Red, Yes

shop3, 1/3/2016, Red, No

shop4, 1/4/2016, Red, No

shop5, 1/5/2016, Red, Yes

shop6, 1/6/2016, Red, Yes

shop1, 1/1/2016, Green, No

shop2, 1/2/2016, Green, No

shop3, 1/3/2016, Green, Yes

shop4, 1/4/2016, Green, Yes

shop5, 1/5/2016, Green, No

shop6, 1/6/2016, Green, No

shop1, 1/1/2016, Yellow, Yes

shop2, 1/2/2016, Yellow, Yes

shop3, 1/3/2016, Yellow, No

shop4, 1/4/2016, Yellow, No

shop5, 1/5/2016, Yellow, Yes

shop6, 1/6/2016, Yellow, Yes

];

Attributes:

GENERIC LOAD

RecId, Color, Status

Resident Data

;

See attached example.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Pivot or Straight table without expression

Thu, 16 Mar 2017 10:15:06 GMT

There is simple way ... You must set up minimaly 1 expression, f.e. constant '1'. Then go tab Presentation in chart properties (right mouse button) and in list of columns select your expression (probably last position of list). Under list are options such as Show Column, Hide Column, Conditional ... You know what you need to select now