want to see the comparision with all unselected values against the selected value of dimension

[Sulafah]

I have a table fact table that has branch id and sales amount, I want to see the sales value of all branches against the branch I selected.

Fact Table

BR_ID, Sales

Dimension Table

BR_ID, BR_Name

[tresesco · Accepted solution]

You could use set analysis component e() for the same. If you need more specific help, try to share a sample app explaining the expected output there.

[JordyWegman]

Hi,

You can use set analysis, but also alternate states would be a good option, if you have some experience with Qlik. This way you can have more flexibility in comparing branches.

Jordy

Climber

[Sulafah]

Thank you very much e() did the job, can we use e() only when dimension is selected otherwise it show all the records

[tresesco]

Yes, you can put an if condition like:

If (getselectedcount(dimension), <expression>, <expression2>)

[Sulafah]

Thank you sir