Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
clovati
Partner - Creator
Partner - Creator

Pivot or Straight table without expression

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!

Capture.PNG

4 Replies
settu_periasamy
Master III
Master III

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

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;

1.png

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Not applicable

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