Discussion board where members can get started with Qlik Sense.
i have a question: my table does look like:
i want to create this view:
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
How is your data being loaded if it is in the format
Then you should be able to present your data on the format you want via pivot
thanks a lot for your responce,
my data do look like:
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
What do you mean with slightly modify? How can i achieve this structure? with help of Crosstable?
try like this:
Load * Inline [
Drop Table Tab;
Load the data as it is
(ooxml, embedded labels, table is Sheet3);
Now Add Dimension : Project & Phase
Now Add Expression :
Bill : Sum(Bill)
Budget : Sum(Budget)
Now it will show like this
Now Press Done and Drag Phase before Measure
Apply the changes and it's done
Thanks a lot for your responce Nallani
Hi Basak, thanks a lot for your responce and time