Pivot or Straight table without expression

[clovati]

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!

[settu_periasamy]

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

[maxgro]

in script

SET DateFormat='M/D/YYYY';

S:

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

];

T:

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;

[rwunderlich]

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

[#5]

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