Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gowthamram
Contributor
Contributor

Qlik sense pivot table question

Hello All,

I am new to Qlik sense developement.

Can any one help me to achieve this in QlikSense pivot table.

i have only two fields in excel as mentioned in below input table and would like to show this in Qliksense pivot table as below given output table

Input table:

  

MessagesType
RTR-RLE-DosingRT-Dosing
RTR-RLE-Dosing
RTR-RLE-EfficaryRT-Effficary
RTR-RLE-Expectation-PatientRT-Expection-FLS
RTR-RLE-Expectation-PatientRT-Expection-ISR

Output in Qliksense Pivot table:

  

MessagesType
RTR-RLE-DosingRT-Dosing
RTR-RLE-Dosing
RTR-RLE-EfficaryRT-Effficary
RTR-RLE-Expectation-PatientRT-Expection-FLS
RT-Expection-ISR

Thanks in advance.

GDK

8 Replies
d_prashanthredd
Creator III
Creator III

What is the difference btwn input and output table?

Can you elaborate your requirement?

gowthamram
Contributor
Contributor

Hi Prashanth,

In the input table, for the same message we have two different types.

ex:

Message                                              Type

RTR-RLE-Expectation-PatientRT-Expection-FLS
RTR-RLE-Expectation-PatientRT-Expection-ISR

I need the output in pivot table as below i.e. one message should be displayed and types should be both.

Message                                      Type

RTR-RLE-Expectation-PatientRT-Expection-FLS
RT-Expection-ISR

Hope it is clear.

GDK

devarasu07
Master II
Master II

Hi,

There is no measure? only dimension used? Tks

devarasu07
Master II
Master II

Hi,

by default pivot table will off the repeated value.

Capture.JPG

gino2780
Creator
Creator

Hello Gowtham,

try to solve your problem with the mapping load/apply map command:

what is mapping load and apply map?

Don't join - use Applymap instead

Greets,

Giacinto

devarasu07
Master II
Master II

Hi,

Why do we need to use applymap here? actually he is just looking value suppression feature with only two measure.

PS: by default pivot table has this feature but need at-least one measure.

gowthamram
Contributor
Contributor

Hi Dev,

Yes. there is no measure. Only two dimensions.

-GDK

gowthamram
Contributor
Contributor

Hi Dev,

I tried in this way. my requirement is that i should not show the measure in the chart. Need only two dimensions i.e. Messages and Type.

Thanks

GDK