Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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