Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

beck_bakytbek
Valued Contributor III

Pivottable in Qlik Sense

Hi Folks,

i have a question: my table does look like:

Phase 1Phase 2Phase 3
Projekt ABill1002560
now:Budget2553
Delta7520

57

i want to create this view:

Phase 1Phase 2Phase 3
Projekt ABillBudgetDeltaBillBudgetDeltaBillBudgetDelta
10025752552060357

i have tried to create this view by using of ValueList-Function, but i didnt achieve any results.

Does anybody have any idea?

Thanks a lot

Beck

8 Replies
ogster1974
Honored Contributor II

Re: Pivottable in Qlik Sense

How is your data being loaded if it is in the format

Project

Phase

Measure

Value

Then you should be able to present your data on the format you want via pivot

beck_bakytbek
Valued Contributor III

Re: Pivottable in Qlik Sense

Hell Andy,

thanks a lot for your responce,

my data do look like:

PhaseProjetBillBugdet
1Projekt A10025
2Projekt A255
ogster1974
Honored Contributor II

Re: Pivottable in Qlik Sense

Slightly modify it so the bill and budget are facts about the project phase so

Project phase measure value

A, 1, bill, 100

A, 1, budget, 25

A, 2, bill, 25

A, 2, budget, 5

beck_bakytbek
Valued Contributor III

Re: Pivottable in Qlik Sense

What do you mean with slightly modify? How can i achieve this structure? with help of Crosstable?

ChennaiahNallani
Contributor III

Re: Pivottable in Qlik Sense

try like this:

Tab:

Load * Inline [

Phase,Projet,Bill,Bugdet

1,Projekt A,100,25

2,Projekt A,25,5

];

CrossTable(PhaseName,Value,2)

Load

Phase,

Projet,

Bill,Bugdet

Resident Tab;

Drop Table Tab;

pritamb89
Contributor

Re: Pivottable in Qlik Sense

Load the data as it is

Tab:

LOAD

    Phase,

    Projet,

    Bill,

    Bugdet,

    Delta

FROM [lib://Data/Book3.xlsx]

(ooxml, embedded labels, table is Sheet3);

Now Add Dimension : Project & Phase

Now Add Expression :

Bill : Sum(Bill)

Budget : Sum(Budget)

Delta: Sum(Delta)

Now it will show like this

Capture1.PNG

Now Press Done and Drag Phase before Measure

Capture2.PNG

Apply the changes and it's done

Capture3.PNG

beck_bakytbek
Valued Contributor III

Re: Pivottable in Qlik Sense

Thanks a lot for your responce Nallani

beck_bakytbek
Valued Contributor III

Re: Pivottable in Qlik Sense

Hi Basak, thanks a lot for your responce and time

Community Browser