Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-10-24 04:06 AM

Qlikview set analysis in chart expression based on different column

I have a chart showing Issued Qty for all transactions from 'From Location' to 'To Location' as follows.

QlikViewSetAnlysis1.jpg


Now I want to show one more column. In that I want to show transaction qty from 'To Location' to 'From Location'. To elaborate, the first row shows Qty issued from Pharmacy to '3rd Flr - NEW AC WARD'. So now in the next column, I wish to show the qtys issued from '3rd Flr - NEW AC WARD' to pharmacy.

Some trick using set analysis would do, but I am not well versed with Set analysis. Please kindly help.

278 Views
0 Likes
1 Reply
swuehl
MVP
MVP
‎2015-10-24 08:44 AM

Set Analysis probably won't help, since it's evaluated once per chart, not per dimension row.

Since your two dimensions already filter the data, it's quite hard to get a different filter for From / To Location in a second column.

I think it would be best to review your data model if there can be something changed to assist your kind of analysis.

Could you upload a small sample QVW?

161 Views
0 Likes