Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Create 2 Pivot tables to filter Data based on Values & Text

Hi,

I need to create 2 pivot tables;

1.  Show Solely Values

2.  Show Solely Text

How do I do this? Can someone please guide me on this?

2nd Question:  I only manage to show the data when I input the expression as 'MaxString(QuestionData)'.  If i just input '=QuestionData', nothing is shown.

Had attached a sample dashboard for reference.

Thanks

Chun Wey

6 Replies
Highlighted
Not applicable

Hi,

Any guidance will be greatly appreciated.

Thanks

Chun Wey

Highlighted
Not applicable

Hi All,

any help appreciated.

Attached is the qvw.

it is under Monthly Performance tab:

1.  Raw score button -> Show value only

2.  Comments -> Show comments only

Thanks

Chun Wey

Partner
Partner

Hello,

You need to change the chart type to straight or pivot table.

You are trying to show a text value in a bar chart. So it does not work because QV does not know how to draw a bar using text values.

BR

Serhan

Highlighted
Not applicable

Hi Serhan,

Both are already in pivot table.

You have to go to Monthly Performance Tab -> click on the Raw Score button (will be highlighted in red) if selected.  OR you can click on Comments button (will be highlighted in red) if selected.

Thanks

Chun Wey

Highlighted
Partner
Partner

Hi Chunwey,

I'm talking about Comments button as well. Raw Score seems fine.

It is a bar chart on the sample you sent.

BR

Serhan

Highlighted
Not applicable

Hi Serhan,

Noted, i have removed the bar chart.

As for the comment, it is in pivot table.

I have to use MaxString to get both the values and text out.  Only concern if this is the correct approach to go about.

Thanks.