Qlik sense pivot table question

Anonymous · ‎2017-08-16

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:

Output in Qliksense Pivot table:

Thanks in advance.

GDK

d_prashanthredd · ‎2017-08-16

What is the difference btwn input and output table?

Can you elaborate your requirement?

Anonymous · ‎2017-08-17

Hi Prashanth,

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

ex:

Message Type

RTR-RLE-Expectation-Patient	RT-Expection-FLS
RTR-RLE-Expectation-Patient	RT-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-Patient	RT-Expection-FLS
	RT-Expection-ISR

Hope it is clear.

GDK

devarasu07 · ‎2017-08-17

Hi,

There is no measure? only dimension used? Tks

devarasu07 · ‎2017-08-17

Hi,

by default pivot table will off the repeated value.

gino2780 · ‎2017-08-17

Hello Gowtham,

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

Greets,

Giacinto

devarasu07 · ‎2017-08-17

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.

Anonymous · ‎2017-08-17

Hi Dev,

Yes. there is no measure. Only two dimensions.

-GDK

Anonymous · ‎2017-08-17

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

Related Topics