Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gowthamram
New 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

Tags (1)
8 Replies
d_prashanthredd
Contributor III

Re: Qlik sense pivot table question

What is the difference btwn input and output table?

Can you elaborate your requirement?

gowthamram
New Contributor

Re: Qlik sense pivot table question

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
Honored Contributor II

Re: Qlik sense pivot table question

Hi,

There is no measure? only dimension used? Tks

devarasu07
Honored Contributor II

Re: Qlik sense pivot table question

Hi,

by default pivot table will off the repeated value.

Capture.JPG

gino2780
Contributor

Re: Qlik sense pivot table question

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
Honored Contributor II

Re: Qlik sense pivot table question

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
New Contributor

Re: Qlik sense pivot table question

Hi Dev,

Yes. there is no measure. Only two dimensions.

-GDK

gowthamram
New Contributor

Re: Qlik sense pivot table question

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

Community Browser