Discussion board where members can get started with Qlik Sense.
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
Output in Qliksense Pivot table:
Thanks in advance.
What is the difference btwn input and output table?
Can you elaborate your requirement?
In the input table, for the same message we have two different types.
I need the output in pivot table as below i.e. one message should be displayed and types should be both.
Hope it is clear.
There is no measure? only dimension used? Tks
by default pivot table will off the repeated value.
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
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.
Yes. there is no measure. Only two dimensions.
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.