topic Re: How to freeze value in table when select other data from list box? in QlikView

How to freeze value in table when select other data from list box?

panwipa2528 — Thu, 09 Feb 2017 03:55:52 GMT

I need to freeze value in fields (All Member, Total Buy) when I select data from list box.

Before

Brunch	All Member	Total Buy	Member got Premium	Total buy whem Member got Premium
A	17,932	176,097,832	13,368	102,256,280
B	13,305	146,108,394	9,626	81,355,025
C	16,736	145,349,116	11,865	79,188,964
D	10,830	109,478,043	7,496	60,535,767
Total	58,803	577,033,385	42,355	323,336,036

After

Brunch	All Member	Total Buy	Member got Premium	Total buy whem Member got Premium
A	17,932	176,097,832	10,618	73,152,506
B	13,305	146,108,394	7,317	52,065,784
C	16,736	145,349,116	9,330	54,765,378
D	10,830	109,478,043	5,578	40,548,605
Total	58,803	577,033,385	32,843	220,532,273

Anil_Babu_Samineni — Thu, 09 Feb 2017 04:02:58 GMT

Didn't clear to me, Can you explain bit more?

panwipa2528 — Thu, 09 Feb 2017 09:50:32 GMT

Thank you for your question
I have data 4 Columns
1. All Member = count(distinct membercode)
2. Total Buy = sum(total_buy)

3. Member Got Premium = Count(Distinct {$<Condition= {'Premium'}>} membercode)

4. Total buy when Member got Premium= sum({$<Condition= {'Premium'}>} total_buy)

When I choose data from list box (Sample Year, Product), I don't want (1) and (2) to change, i need to freeze.

Thu, 09 Feb 2017 10:03:28 GMT

yu have to add {<[Sample Year]=,Product=>} in your table expression..

Like this sample expression-> =Sum({<[Social Media]>}[No of Feedback])

Whatever your expression may be, add those exceptions in it.

sdmech81 — Thu, 09 Feb 2017 10:05:47 GMT

May be,

in 1 And 2 expression Write like:

= count({<year=,product=>}distinct membercode)

Total Buy = sum({<year=,product=>}total_buy)

its should work plss try

Sachin

sdmech81 — Thu, 09 Feb 2017 10:07:00 GMT

Hi,

Whenever u don't don't want some thing should not b effected based on some selection above said is the syntax.

Sachin

vardhancse — Thu, 09 Feb 2017 10:16:37 GMT

Hi,

If both are dimensions then use set analysis:

=Sum({<All Member=, Total Buy=>}Member got Premium)