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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
fashid
Specialist
Specialist

expression is not returning correct values against dimension.

Hi Friends,

I need a help with an expression in my chart.

I have several parameters and their associated MTD scores in my application.which is shown in a chart.

Now I have created a straight table which gives me the total score of all the parameters.

Now the the problem the total score is getting calculated correctly but its not showing according to the branch dimension which i have used in the chart.

Could anybody point out what the issue could be.

I am attaching my sample app and the expected output.

Regards

Nadeem

24 Replies
sunny_talwar

that worked... hahaha I was change the date format and not the actual date

fashid
Specialist
Specialist
Author

lol this type of communication has its own problems

sunny_talwar

Got it to work:

Don't ask me how and why it works, but it did: Remove '=' from your variable and use $ sign expansion in your chart's expressions ($())

Table.PNG

Best,

Sunny

fashid
Specialist
Specialist
Author

AWWWW CRA.......

Got it Thanks magician and yes i wont ask you because i got it ..

It was such a silly thing on my part

Thank you soo much sunnyy for bringing it to light .

Regards,

Nadeem

sunny_talwar

No problem.

Best,

Sunny