Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted

Re: Pivot or Straight table without expression

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

Highlighted
MVP
MVP

Re: Pivot or Straight table without expression

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: Pivot or Straight table without expression

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

Highlighted
Not applicable

Re: Pivot or Straight table without expression

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