Drill down in the Pivot Table

qliktoview123 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I need to drill down in the expressions.

for example:

I have Total Revenue which is the sum of Offshore,Onsite,Short term,Offsite revenue.

so what i want is when i click on Total Revenue,it expands and show other revenue under it and I also want to drill down the revenue further.

I have attached the qvw.Please help me out.

Re: Drill down in the Pivot Table

boorgura — Wed, 06 Jul 2016 14:03:03 GMT

Ideally, you will have model it within the script.

say something like this:

LOAD

'Total Revenue' as [Category 1],

'off shore' as [Category 2],

[Off shore revenue] as Dollar_Amount

resident TableName

Concatenate

LOAD

'Total Revenue' as [Category 1],

'on site' as [Category 2],

[On Site revenue] as Dollar_Amount

resident TableName

You will have to expand your script to all the scenarios.

Or you will have to conditionally show/hide expression, based on ACTIONS on the UI