Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

i want to freeze dimension from current selection

Hi Friends,

i am facing a critical situation in pivot table view to freeze dimension  from calender selection.

I have multiple dimensions and only one expression.i want to ignore all dimensions (retain all dimension values) from calender selection but want expression value to change as per calender selection. for example

i have 10 dimension and no of records in each dimension=50

i have 1 expression and number records are depends on calender selection.

i want to fix 10 dimension with 50 number of records and want to show expression value  on calender selection basis.

so kindly help me friends

Pawan Panwar

17 Replies
Highlighted
MVP
MVP

Re: i want to freeze dimension from current selection

Consider below example..

You have dimensions as

Customer

Country

Brand

Supplier

Expression = SUM(Sales)

If you want your SUM(Sales) only change if there are some selection or changes in Calendar field

i.e. Date, Month, Year, Quarter etc

But not due to change in Customer, Country, Brand, Supplier....

You can change you Expression as below...

SUM({$<Customer = , Country = , Brand = , Supplier = >}Sales)

i.e Your value for particular dimension will not change if you use your dimension in expression under set analysis as above...

Highlighted
Not applicable

Re: i want to freeze dimension from current selection

Hi Manish,

There is some mis understanding i want freeze the dimension value.

E.g. If we have 50 rows(values) in dimentions then they must be 50at all times regardless of what calendar selection is. Also only expression values should change in case of change in calendar selection and if there is some mismatch with dimension values it should return 0 or null.

Please suggest.

Regards

Pawan Panwar

Highlighted
MVP
MVP

Re: i want to freeze dimension from current selection

can you provide little sample data with your requirements?

Highlighted
Not applicable

Re: i want to freeze dimension from current selection

Before calender salection value

Group2 Group3 SaleAmount

AHD AEGIS1 13659.12

AHD AHD1 2273646.87

AHD AHD1A 9736.49

AHD AHD5 469956.43

AHD AHD5A 30832.46

AHD AHD32 120350.27

AHD AHD60 376254.3

AHD AHD66 232544.35

AHD AHD67 3.55

AHD AHD78 85093.17

AHD AHD82 0.73

AHD AHD83 167265.92

AHD AHD84 304973.73

AHD AHD86 126707.21

AHD AHD89 166495.72

AHD AHD97 63685.52

AHD AHD99 157665.35

AHD AHD101 795121.37

AHD AHD106 171938.2

AHD AHD111 925982.06

AHD AHD118 4872.95

AHD AHD120 939.84

After selection value shown as

Group2 Group3 SaleAmount

AHD AEGIS1 1659.12

AHD AHD1 646.87

AHD AHD1A 9736.49

AHD AHD5 956.43

AHD AHD5A 832.46

AHD AHD32 350.27

AHD AHD60 54.3

AHD AHD66 544.35

AHD AHD67 3.55

AHD AHD78 93.17

AHD AHD82 0.73

AHD AHD83 7265.92

AHD AHD84 4973.73

but i need the dimension value is same even if there is no value for a dimension in expression

want to show same as below(all dimension records to remain on the grid if there is not value from the expression)

Group2 Group3 SaleAmount

AHD AEGIS1 1659.12

AHD AHD1 646.87

AHD AHD1A 9736.49

AHD AHD5 956.43

AHD AHD5A 832.46

AHD AHD32 350.27

AHD AHD60 54.3

AHD AHD66 544.35

AHD AHD67 3.55

AHD AHD78 93.17

AHD AHD82 0.73

AHD AHD83 7265.92

AHD AHD84 4973.73

AHD AHD86 0

AHD AHD89 0

AHD AHD97 0

AHD AHD99 0

AHD AHD101 0

AHD AHD106 0

AHD AHD111 0

AHD AHD118 0

AHD AHD120 0

Regards

Pawan Panwar

Highlighted
MVP
MVP

Re: i want to freeze dimension from current selection

Under Dimension Tab

Select Show All Values

Under Presentation Tab

Untick Suppress Zero Values

Highlighted
Not applicable

Re: i want to freeze dimension from current selection

After done that result shown as

Group2 Group3 SaleAmount

AHD AEGIS1 1659.12

AHD AHD1 646.87

AHD AHD1A 9736.49

AHD AHD5 956.43

AHD AHD5A 832.46

AHD AHD32 350.27

AHD AHD60 54.3

AHD AHD66 544.35

AHD AHD67 3.55

AHD AHD78 93.17

AHD AHD82 0.73

AHD AHD83 7265.92

AHD AHD84 4973.73

- AHD86 0

- AHD89 0

- AHD97 0

- AHD99 0

- AHD101 0

- AHD106 0

- AHD111 0

- AHD118 0

- AHD120 0

But I required same as below

Group2 Group3 SaleAmount

AHD AEGIS1 1659.12

AHD AHD1 646.87

AHD AHD1A 9736.49

AHD AHD5 956.43

AHD AHD5A 832.46

AHD AHD32 350.27

AHD AHD60 54.3

AHD AHD66 544.35

AHD AHD67 3.55

AHD AHD78 93.17

AHD AHD82 0.73

AHD AHD83 7265.92

AHD AHD84 4973.73

AHD AHD86 0

AHD AHD89 0

AHD AHD97 0

AHD AHD99 0

AHD AHD101 0

AHD AHD106 0

AHD AHD111 0

AHD AHD118 0

AHD AHD120 0

Highlighted
MVP
MVP

Re: i want to freeze dimension from current selection

your sample apps will be helpful to check and give you answer..

Highlighted
Not applicable

Re: i want to freeze dimension from current selection

i will send you on monday. thanks for support.

Highlighted
Not applicable

Re: i want to freeze dimension from current selection

Hi Manish,

kindly find attached sample qvw.

I want same output of dimension on calander selection as(without selection) but want to change only in expression on calander selection.

Regards

Pawan Panwar