Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Adding static lines in pivot table

HI folks, I am using a pivot table with below attributes - Country,Currency,[Other Lines] and measure - [Amount]

Everything is now simple. I have a requirement to add 3 static lines after each currency (let's say Line1/2/3) which calculate second measure and it doesnt have split across next dim i.e. [Other Lines]

Now i tried to add it as new dim using ValueList and calculate value, but issue that all values  [Other lines} is now coming under each of these static lines 1,2,3. Which is obvious behaviour of pivot table. I need output like below -

United States
    USD
          Line1
          Line2
          Line3
     Other Lines
UAE
    Dirhams
          Line1
          Line2
          Line3
     Other Lines

 

Values Line1,2,3 should NOT be expanded and no dimension should come under those lines. Hope I was able to put requirement clearly. Any help would be much appreciated guys.

TIA.

Labels (3)
0 Replies