Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
beck_bakytbek
Master
Master

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
Partner - Master II
Partner - Master II

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
Master
Master
Author

Hell Andy,

thanks a lot for your responce,

my data do look like:

PhaseProjetBillBugdet
1Projekt A10025
2Projekt A255
ogster1974
Partner - Master II
Partner - Master II

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
Master
Master
Author

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

ChennaiahNallani
Creator III
Creator III

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;

jerryyang756
Creator
Creator

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
Master
Master
Author

Thanks a lot for your responce Nallani

beck_bakytbek
Master
Master
Author

Hi Basak, thanks a lot for your responce and time