Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
panwipa2528
Contributor III
Contributor III

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

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


Before

BrunchAll MemberTotal BuyMember got PremiumTotal buy whem Member got Premium
A17,932176,097,83213,368102,256,280
B13,305146,108,3949,62681,355,025
C16,736145,349,11611,86579,188,964
D10,830109,478,0437,49660,535,767
Total58,803577,033,38542,355323,336,036

After

BrunchAll MemberTotal BuyMember got PremiumTotal buy whem Member got Premium
A17,932176,097,83210,61873,152,506
B13,305146,108,3947,31752,065,784
C16,736145,349,1169,33054,765,378
D10,830109,478,0435,57840,548,605
Total58,803577,033,38532,843220,532,273
1 Solution

Accepted Solutions
sdmech81
Specialist
Specialist

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

View solution in original post

6 Replies
Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
panwipa2528
Contributor III
Contributor III
Author

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.

Not applicable

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
Specialist
Specialist

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

View solution in original post

sdmech81
Specialist
Specialist

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
Specialist III
Specialist III

Hi,

If both are dimensions then use set analysis:

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