topic Re: Show all months in pivot chart regardless of selections in QlikView

Show all months in pivot chart regardless of selections

Sat, 14 Feb 2015 13:05:35 GMT

Hello all

Please can you advise me (a novice!) on how I can keep all the months all visible in my pivot chart below, but still make other selections dependent on selections in other sheets (as is the default)?

On the other sheets you can only select one month at a time (which is what I want) - but this chart below switches between a pivot chart and a line chart to show the differences over time, so I always want all the months showing....

Thanks

Chloe

Re: Show all months in pivot chart regardless of selections

Sat, 14 Feb 2015 13:11:26 GMT

sorry - screen shot didn't attach...

Re: Show all months in pivot chart regardless of selections

MK_QSL — Sat, 14 Feb 2015 14:48:00 GMT

Consider that you have

below dimensions

Item

Year

and below expression

SUM(Sales)

....

If you want TotalSales for all Years even though particular year is selected, you need to bypass Year using set analysis in expression... like below

SUM({<Year=>}Sales)

If you have MonthYear field, you can use the same instead of Year as shown in above example.

To bypass multiple field.. use can use as

SUM({<Field1 =, Field2 =, Field3= >}Sales)

Re: Show all months in pivot chart regardless of selections

Sat, 14 Feb 2015 15:53:30 GMT

Thanks Manish, but I am having trouble putting this into the expression i have:

IF(Dimensionality() = 0,
IF(
'('&sum(NonCount)&')' & ' ' &
num(sum(CompCount)/(Sum(NonCount)+Sum(CompCount)),'#,##0.0%') = '(0) ', 'N/A',
num(sum(CompCount)/(Sum(NonCount)+Sum(CompCount)),'#,##0.0%'))
,

IF(
'('&sum(NonCount)&')' & ' ' &
num(sum(CompCount)/(Sum(NonCount)+Sum(CompCount)),'#,##0.0%') = '(0) ', 'N/A', '('&sum(NonCount)&')' & ' ' &
num(sum(CompCount)/(Sum(NonCount)+Sum(CompCount)),'#,##0.0%')))

my dimensions are MONTH and Compliance Category

Are you able to advise on how i insert the {MONTH=>} into the expression below? when I do it brings out incorrect data for the selection that is made?

Thanks for your help so far

Chloe

Re: Show all months in pivot chart regardless of selections

MK_QSL — Sat, 14 Feb 2015 16:35:14 GMT

instead of

sum(NonCount)

try

sum({<Month = >}NonCount)

at every place

Re: Show all months in pivot chart regardless of selections

Sat, 14 Feb 2015 17:01:22 GMT

Fab - thank you so much!