Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
skumarqv11
Contributor III
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
vishsaggi
Champion III
Champion III

Are you looking something like this?

Capture.PNG

If yes just use below as your expression in your table:

= 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.

skumarqv11
Contributor III
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

vishsaggi
Champion III
Champion III

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

vishsaggi
Champion III
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.

Capture.PNG

skumarqv11
Contributor III
Contributor III
Author

Hi Vishwarath,

Thanks for your reply.

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.

vishsaggi
Champion III
Champion III

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