Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Constant Dimension column

Hi All

In below screen I want circled blue column always even if I select SNm (circled Red).

SNm JO should always be there, when S1, S2, S3 can be vary

How do I please? QV attached

Thanking you

Capture.JPG

1 Solution

Accepted Solutions
danieloberbilli
Specialist II
Specialist II

Please find attached:

sum({$<SId=, SNm={'JO'}+SNm>} Sales )

View solution in original post

4 Replies
pokassov
Specialist
Specialist

Hi Satish!

sum({$<SNm={'JO'}>+$} Sales )

danieloberbilli
Specialist II
Specialist II

Please find attached:

sum({$<SId=, SNm={'JO'}+SNm>} Sales )

Anonymous
Not applicable
Author

Hi Cepren(I am Sorry for the name pronounced)

I appreciate your helpful answer, it helped lot.

Thanking you

Anonymous
Not applicable
Author

Hi Daniel

I appreciate your helpful answer,  Amazing short but powerful solution

Thanking you