# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
cancel
Showing results for
Did you mean:
Contributor III

## Pivot chart with different level sub total?

Hi Folks,

I need to create a pivot table in different way. I have attached the Excel file which has sample dataset and Pivot structure.

Also attaché the QVW file which I have created with simple pivot.

Can you please suggest me how to do that?

Please suggest if we have any different way to implement it?

Thanks,

Shravan

6 Replies
Champion III

Are you looking something like this?

= IF(Dimensionality() = 2, Sum( {<BID={'N/A'}>} Value)&'/'&Sum( {<BID -={'N/A'}>} Value),sum(Value))

However, i would like to know if your BID will always have a value N/A. Let me know.

Contributor III
Author

Hi Vishwarath,

Thanks for your reply, But I need like below. I want to Ignore N/A from BID and Country.

My result should be like this.

Level=2 country result/ all BID Result.(150/90), Because I may have N/A or may not so.

All BID we can get that, But I am trying to get the value for Level=2 country.

I need a expression to get 150 value which is country level=2 value

Champion III

But your country level 2 has a BID with value 'N/A' right?

Champion III

Check this?

= IF(Dimensionality() = 2, Sum( {<BID -={'N/A'}>} Value)&'/'&Sum({< BID = {'N/A'} >}Value), sum(Value))

For Dim BID use like below and in the expr use the above and let me know.

Contributor III
Author

Hi Vishwarath,

Its like hierarchy concept. I have BID's values for Each country and Country also have different Value.

Here My case is I have a country value which is doesn't have BID (i.e. N/A here), Its a total country level value 150.

I have BID's in each country that is BID1,BID2,BID3 etc.

Each BID's having values.

My scenario is I want to compare the values like below.

Country Level Value/ sum of BID's in that Country (150/90).

There is difference in 150-90=60.

To check this N/A is the country level value, BID's each BID's value in the same Country.

Champion III

Sorry quite did not follow you, can you tell me what exactly you are expecting to see in your Pivot?